hive> CREATE TABLE csv1_table(a string, b string)
> ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
> WITH SERDEPROPERTIES (
> "separatorChar" = ",",
> "quoteChar" = "'",
> "escapeChar" = "\\"
> )
> STORED AS TEXTFILE;
OK
Time taken: 1.151 seconds
使用SERDE解析器即可 :D
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024