FAILED: ParseException line 1:17 cannot recognize input near 'student2' 'select' 'id' in destination specification

 

hive向表中插入数据时报错：

FAILED: ParseException line 1:17 cannot recognize input near 'student2' 'select' 'id' in destination specification

?

1 2 3 4 5 6 7

错误：   insert overwrite student2 select id,name from student;   正确：   insert overwrite table student2 select id,name from student;

 

?

1 2	语法： INSERT (INTO | OVERWRITE) TABLE tablename [PARTITION (partcol1[=val1], partcol2[=val2] ...)] VALUES values_row [, values_row ...]

 但是在使用into插入数据时，是可以省略table的（可写可不写）,但是使用overwrite需要写table关键字。

?

1 2	例子： insert into student2 values(55,'22');<br>insert into table student2 values(55,'22');<br>效果一样<br>