为什么Hive没有像MySQL那样的FIELDS ENCLOSED BY？

本文介绍了为什么Hive没有像MySQL那样的FIELDS ENCLOSED BY？的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述 这里是我的情况： 输入行： vijay< \t> a-b-c，a-c-d，a-d-c kumar< \t> abc，bcd 我创建了如下表格： hive> create table user_infos（name string，path ARRAY< String> --i只需要数组） ROW FORMAT DELIMITED FIELDS TERMINATED BY' \''收藏品 TERMINATED BY'，'线条终止'\ n'存为TEXTFILE; 收到的输出： hive> select * from user_infos; vijay[** \abc\**，** \acd\**，** \adc\**] kumar[** \abc \**，** \bcd \**] 这里的问题是：我不想要双引号，即 \ 必需输出： vijay [abc，acd，adc] kumar [abc，bcd] 是否有任何为什么要使用铜stom Serde 。任何东西都像ENCLOSED BY在mysql中一样？解决方案我也遇到了同样的问题，因为我的字段用双引号并用分号（;）分隔。我的表名是employee1。 所以我搜索了链接，并找到了完美的解决方案。 @ ramisetty.vijay：是的，我们必须为此使用serde。请使用此链接下载serde jar： https：// github .com / downloads / IllyaYalovyy / csv-serde / csv-serde-0.9.1.jar 然后按照以下步骤使用蜂巢提示： 添加jar路径/ to / csv-serde.jar; 创建表employee1（id字符串，名称字符串，addr字符串）行格式serde'com.bizo.hive.serde.csv.CSVSerde' with serdeproperties（separatorChar=\;，quoteChar=\）存储为文本文件; ，然后使用以下查询从给定路径加载数据： 将数据本地inpath'path / xyz.csv'加载到表employee1中; 然后运行： select * from employee1; 谢谢。 here is my case :input lines: "vijay" <\t> "a-b-c","a-c-d","a-d-c" "kumar" <\t> "a-b-c","b-c-d""i created table like this :hive >create table user_infos(name string, path ARRAY<String> --i need array only)ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' COLLECTION ITEMS TERMINATED BY ',' LINES TERMINATED BY '\n' STORED AS TEXTFILE ;output received :hive > select * from user_infos ;"vijay" ["**\"a-b-c\"**","**\"a-c-d\"**","**\"a-d-c\"**"]"kumar" ["**\"a-b-c\"**","**\"b-c-d\"**"] problem here is : i don't want double quotes i.e., \" Required output :vijay ["a-b-c","a-c-d","a-d-c"] kumar ["a-b-c","b-c-d"] Is there any why to achieve this not using custom Serde. Any thing like ENCLOSED BY like in mysql? 解决方案 I was also stuck with the same issue as my fields are enclosed with double quotes and separated by semicolon(;). My table name is employee1.So I have searched with links and I have found perfect solution for [email protected]: Yes, We have to use serde for this. Please download serde jar using this link : https://github.com/downloads/IllyaYalovyy/csv-serde/csv-serde-0.9.1.jarthen follow below steps using hive prompt :add jar path/to/csv-serde.jar;create table employee1(id string, name string, addr string)row format serde 'com.bizo.hive.serde.csv.CSVSerde'with serdeproperties("separatorChar" = "\;","quoteChar" = "\"")stored as textfile;and then load data from your given path using below query:load data local inpath 'path/xyz.csv' into table employee1;and then run :select * from employee1;Thanks. 这篇关于为什么Hive没有像MySQL那样的FIELDS ENCLOSED BY？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！