Member since
08-12-2021
3
Posts
0
Kudos Received
0
Solutions
08-12-2021
09:30 PM
1. in Hive we can use OpenCSVSerde to remove the double quotation marks, however this is not compatible with Impala. is there any equivalent OpenCSVSerde in Impala? 2.ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' ESCAPED BY '\\' WITH SERDEPROPERTIES ( "separatorChar" = "|" , "quoteChar" = "\"" ) is not also working.
... View more
08-12-2021
05:39 AM
I have a csv data which I have to load in impala/hive. does anyone knows how to remove the double quotation mark in the output? Here is my sample create table scripts. CREATE EXTERNAL TABLE schema.table ( id int, name STRING, desc STRING, desc1 STRING ) ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' WITH SERDEPROPERTIES ('field.delim'='|', 'serialization.format'='|') STORED AS TEXTFILE LOCATION '/user/folder/schema/table'
... View more
Labels:
- Labels:
-
Apache Hive
-
Apache Impala