thanks, it's the version's problem ,i am using 0.13.1 From: raunak.jha...@gmail.com Date: Fri, 13 Mar 2015 17:12:15 +0530 Subject: Re: insert table error To: user@hive.apache.org
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);
