티스토리 뷰

공부

[Hive] CSV delimiter table

seunggabi 승가비 2021. 3. 14. 04:51
728x90
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
WITH SERDEPROPERTIES (
   "separatorChar" = ",",
   "quoteChar"     = "\""
) 

community.cloudera.com/t5/Support-Questions/How-to-remove-double-quote-from-csv-file-at-time-of-loading/td-p/104622

 

How to remove double quote from csv file at time of loading csv file into Hive orc tabel using data frame temp table.,How to rem

I m loading csv file into Hive orc table using data frame temporary table. After loading into Hive table data is present with double quote. Input file "Arpit","Jain",123 "Qwee","ffhh",5778 How to remove this double quote at time of inserting into Hive tabl

community.cloudera.com

 

728x90

'공부' 카테고리의 다른 글

[k8s] documents  (0) 2021.03.17
[Jenkins] build by curl parameters  (0) 2021.03.17
[Hive] CSV delimiter table  (0) 2021.03.14
[Java] Double.intValue()  (0) 2021.03.14
[Spark] current_date() & current_timestamp()  (0) 2021.03.14
[Python] max float  (0) 2021.03.14
댓글
댓글쓰기 폼