You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by zhangjp <sm...@hotmail.com> on 2015/03/13 12:13:04 UTC
insert table error
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);
Re: insert table error
Posted by Alan Gates <al...@gmail.com>.
What Hive version are you using? What error message did you get?
Alan.
> zhangjp <ma...@hotmail.com>
> 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
> VALUES ('fred flintstone', 35, 1.28), ('barney rubble', 32, 2.32);
Re: insert table error
Posted by Raunak Jhawar <ra...@gmail.com>.
Hi, The INSERT INTO ... VALUES syntax is not supported in Hive 0.13. This
is a feature beyond Hive 0.14 only.
--
Thanks,
Raunak Jhawar
On Tue, Mar 17, 2015 at 8:23 AM, 张奇迹 <sm...@hotmail.com> wrote:
> thanks, it's the version's problem ,i am using 0.13.1
>
> ------------------------------
> From: raunak.jhawar@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.haviv@veracity-group.com> wrote:
>
> What is the error you get?
>
> Daniel
>
> On 13 במרץ 2015, at 13:13, zhangjp <sm...@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);
>
>
>
RE: insert table error
Posted by 张奇迹 <sm...@hotmail.com>.
thanks, it's the version's problem ,i am using 0.13.1
From: raunak.jhawar@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 <da...@veracity-group.com> wrote:
What is the error you get?
Daniel
On 13 במרץ 2015, at 13:13, zhangjp <sm...@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);
Re: insert table error
Posted by Raunak Jhawar <ra...@gmail.com>.
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.haviv@veracity-group.com> wrote:
> What is the error you get?
>
> Daniel
>
> On 13 במרץ 2015, at 13:13, zhangjp <sm...@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);
>
>
Re: insert table error
Posted by Daniel Haviv <da...@veracity-group.com>.
What is the error you get?
Daniel
> On 13 במרץ 2015, at 13:13, zhangjp <sm...@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);