hadoop - 如何编写查询以更改 Hive 中的分隔符

Question

INSERT OVERWRITE DIRECTORY hdfs://gitlabhadoopnn.cs.aibl:8020/ABDF/anus/testdir'  
ROW FORMAT DELIMITED 
FIELDS TERMINATED BY '9' 
SELECT * from TEST;

但执行失败并出现以下错误:

cannot recognize input near 'ROW' 'FORMAT' 'DELIMITED' in statement

请建议一种使用分隔符规范选项执行插入查询的方法。

Answer 1

您的 Hive 是什么版本？你应该检查这个link .

As of Hive 0.11.0 the separator used can be specified; in earlier versions it was always the ^A character (\001). However, custom separators are only supported for LOCAL writes in Hive versions 0.11.0 to 1.1.0 – this bug is fixed in version 1.2.0 (see HIVE-5672).

检查 HIVE-5672和 Hive 版本。

您可以尝试这样做并检查它是否有效:

INSERT OVERWRITE LOCAL DIRECTORY '/tmp/test'  
ROW FORMAT DELIMITED 
FIELDS TERMINATED BY '9' 
SELECT * from TEST;