Re: insert table error

2015-03-16 Thread Raunak Jhawar
> 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.a

RE: insert table error

2015-03-16 Thread 张奇迹
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 onwa

Re: insert table error

2015-03-16 Thread Alan Gates
What Hive version are you using? What error message did you get? Alan. zhangjp March 13, 2015 at 4:13 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 VAL

Re: insert table error

2015-03-13 Thread Raunak Jhawar
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 P

Re: insert table error

2015-03-13 Thread Daniel Haviv
What is the error you get? Daniel > On 13 במרץ 2015, at 13:13, zhangjp 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), ('barne

insert table error

2015-03-13 Thread zhangjp
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);‍