row_format : DELIMITED
[FIELDS TERMINATED BY char [ESCAPED BY char]]
[COLLECTION ITEMS TERMINATED BY char]
[MAP KEYS TERMINATED BY char] [LINES TERMINATED BY char]
[NULL DEFINED AS char] (Note: Only available starting with Hive 0.13)
hive> create table t (i int) row format delimited lines terminated by '\r\n' location '/tmp';
FAILED: SemanticException 1:64 LINES TERMINATED BY only supports newline '\n' right now. Error encountered near token ''\r\n''
hive>
2条答案
按热度按时间qyyhg6bp1#
在配置单元文档中,行分隔符是
char
,因此不应接受两个字符!cwtwac6a2#
仅限当前
\n
支持。看看这张吉拉的票。
允许以结尾的行使用其他字符
“\n”以外的行分隔符在配置单元中引发错误。
演示