Hello, you can use SerDe which has double quotes as default quoting char
CREATE TABLE a1.test (a string, b string ) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde' WITH SERDEPROPERTIES ( "separatorChar" = "," ) Regards Jan From: elango vaidyanathan [mailto:elango...@gmail.com] Sent: čtvrtek 23. března 2017 6:44 To: user@hive.apache.org Subject: Regarding removing double quotes Hi all, I am loading a CSV file into hive. All the columns in the CSV file has values with in the double quotes. How do i remove them and load into hive? Thanks, Elango
