我想创造一个新的世界 Hive 表,但我得到以下错误
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 ')'
e4yzc0pl1#
在您的示例中,创建带有逗号分隔字段的表的语句 Hive 会是
CREATE TABLE salary(id int,name string,salary int,promoted string) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE;
1条答案
按热度按时间e4yzc0pl1#
在您的示例中,创建带有逗号分隔字段的表的语句
Hive
会是