thanks, it's the version's problem ,i am using 0.13.1 From: [email protected] Date: Fri, 13 Mar 2015 17:12:15 +0530 Subject: Re: insert table error To: [email protected]
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 <[email protected]> wrote: What is the error you get? Daniel On 13 במרץ 2015, at 13:13, zhangjp <[email protected]> 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);
