티스토리 뷰

공부

[Hive] CSV delimiter table

승가비 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
[Java] Double.intValue()  (0) 2021.03.14
[Spark] current_date() & current_timestamp()  (0) 2021.03.14
[Python] max float  (0) 2021.03.14
댓글