hive> ADD JAR /home/edureka/Downloads/csv-serde-1.1.2-0.11.0-all.jar

create table test_table(c1 string, c2 string, c3 string)
row format serde 'com.bizo.hive.serde.csv.CSVSerde'               
with serdeproperties(                                             
"separatorChar" = "\,",
"quoteChar"     = "\'",
"escapeChar"    = "\\"
)  
stored as textfile;



LOAD DATA LOCAL INPATH '/home/edureka/Desktop/test.txt' INTO TABLE test_table;