Hive版本:2.3.3
Hadoop版本:2.7.7
想创建一个名为 percent 的HIve表
语句:
create table percent(look_num int,buy_num int,buy_percent float,time string)
row format delimited fields terminated by ',';
报错:
FAILED: ParseException line 1:13 cannot recognize input near ‘percent’ ‘(’ ‘look_num’ in table name
解决方法:
修改表名,即将 percent 修改为其他字符
create table mypercent(time string,buy_num int,look_num int,buy_percent float)
row format delimited fields terminated by ',';
在这里我是将创建的表名 percent 修改为了 mypercent
完美解决!