edureka!

Dear Uma,

Hope you are doing well.

Please refer below solution to your query

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)

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