尝试创建新配置单元表时出错

vwkv1x7d  于 2021-06-24  发布在  Hive
关注(0)|答案(1)|浏览(433)

我想创造一个新的世界 Hive 表,但我得到以下错误

hive> create table salary(id int,name string,salary int,promoted string) 
fields terminated by ',' 
lines terminated by '\n' 
stored as textfile;
FAILED: ParseException line 1:67 missing EOF at 'fields' near ')'
e4yzc0pl

e4yzc0pl1#

在您的示例中,创建带有逗号分隔字段的表的语句 Hive 会是

CREATE TABLE salary(id int,name string,salary int,promoted string) 
ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
STORED AS TEXTFILE;

相关问题