hive> ADD JAR /home/edureka/Downloads/csv-serde-1.1.2-0.11.0-all.jarcreate 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;
hive with multiple delimiters Print
Modified on: Mon, 23 May, 2016 at 6:01 PM
Did you find it helpful? Yes No
Send feedbackSorry we couldn't be helpful. Help us improve this article with your feedback.