How to import a table with delimiter “;” into hive?
我尝试将带有分隔符 “;” 的 CSV 文件导入 Hive，但我无法创建带有 “;” 作为分隔符的 Hive 表。相反，我将 csv 文件的分隔符更改为 “,” 并将其导入配置单元，但我在整数字段中得到空值。
尝试使用”\\\\073″而不是”;”。它应该可以工作。
例如：
|
1
2
3
4
5
|
CREATE EXTERNAL TABLE example(id String,name String)
ROW FORMAT DELIMITED FIELDS TERMINATED BY”\\073″
LINES TERMINATED BY”\
”
STORED AS TEXTFILE LOCATION”/home/location”;
|
来源：https://www.codenong.com/26997094/
微信公众号
手机浏览(小程序)
Warning: get_headers(): SSL operation failed with code 1. OpenSSL Error messages:
error:14090086:SSL routines:ssl3_get_server_certificate:certificate verify failed in
/mydata/web/wwwshanhubei/web/wp-content/themes/shanhuke/single.php on line
57
Warning: get_headers(): Failed to enable crypto in
/mydata/web/wwwshanhubei/web/wp-content/themes/shanhuke/single.php on line
57
Warning: get_headers(https://static.shanhubei.com/qrcode/qrcode_viewid_9268.jpg): failed to open stream: operation failed in
/mydata/web/wwwshanhubei/web/wp-content/themes/shanhuke/single.php on line
57
