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 firstname.lastname@example.org.
We assure you that we will get back to you within 24 hours
edureka! Support Team