Dear Uma,

Hope you are doing well.

Please refer below solution to your query

Data in file abc1
 
"abhi","23","Bhopal"

Command that I have tried

create table myT(name string,age int,city string)
row format delimited 
fields terminated by ','

load data local inpath '/home/edureka/Desktop/abc1' into table myT

select * from myT where name='"abhi"'; // I have provided 3 quotes here(one double qoute and one single quote)

Output
 
 

 
Hope it resolves your query.
If you have any further query,please let us know.

Please share your feedback by choosing either of smiley's.

Please note if you are not happy with the response on this ticket, please escalate it to escalations@edureka.in.
We assure you that we will get back to you within 24 hours 


Regards,
Abhishek Tiwari
edureka! Support Team

Please let us know your opinion on our support experience.


HappyAwesome NeutralJust Okay UnhappyNot Good
197816