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 Fri, 13 Mar 2015 11:42:15 GMT
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