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