What version of Hive are you using. INSERT INTO ... VALUES is supported only from Hive 0.14 onwards.
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DML#LanguageManualDML-InsertingvaluesintotablesfromSQL -- Thanks, Raunak Jhawar m: 09820890034 On Fri, Mar 13, 2015 at 4:45 PM, Daniel Haviv < daniel.ha...@veracity-group.com> wrote: > What is the error you get? > > Daniel > > On 13 במרץ 2015, at 13:13, zhangjp <smart...@hotmail.com> wrote: > > case fail > CREATE TABLE students (name VARCHAR(64), age INT, gpa DECIMAL(3, 2)) > CLUSTERED BY (age) INTO 2 BUCKETS STORED AS ORC; > INSERT INTO TABLE students > VALUES ('fred flintstone', 35, 1.28), ('barney rubble', 32, 2.32); > >
