hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Raunak Jhawar <raunak.jha...@gmail.com>
Subject Re: insert table error
Date Tue, 17 Mar 2015 05:18:36 GMT
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, 张奇迹 <smartzjp@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 <smartzjp@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);‍
>
>
>

Mime
View raw message