Dear Uma,

Hope you are doing well.

Please refer below solution to your query

Data in file abc1

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)


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
We assure you that we will get back to you within 24 hours 

Abhishek Tiwari
edureka! Support Team

Please let us know your opinion on our support experience.

HappyAwesome NeutralJust Okay UnhappyNot Good