我必须从 csv 文件中的配置单元表导出数据,其中字段用双引号引起来。
到目前为止,我可以使用以下查询生成不带引号的 csv
INSERT OVERWRITE DIRECTORY '/user/vikas/output'
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
SELECT QUERY
生成的输出看起来像
1,Vikas Saxena,Banking,JL5
但是,我需要输出为
"1","Vikas Saxena","Banking","JL5"
我尝试将查询更改为
INSERT OVERWRITE DIRECTORY '/user/vikas/output'
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
WITH SERDEPROPERTIES (
"separatorChar" = ",",
"quoteChar" = "\"",
"escapeChar" = "\\"
)
SELECT QUERY
但它显示错误
Error while compiling statement: FAILED: ParseException line 1:0 cannot recognize input near 'ROW' 'FORMAT' 'SERDE'