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, 张奇迹 <[email protected]> wrote: > 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); > > >
