hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stephen Sprague <sprag...@gmail.com>
Subject Re: Hive Query Error
Date Wed, 05 Feb 2014 21:14:48 GMT
file this one under RTFM.


On Wed, Feb 5, 2014 at 9:11 AM, Nitin Pawar <nitinpawar432@gmail.com> wrote:

> its create table xyz stored as sequencefile as select blah from table
>
>
> On Wed, Feb 5, 2014 at 10:37 PM, Raj Hadoop <hadoopraj@yahoo.com> wrote:
>
>> *I am trying to create a Hive sequence file from another table by running
>> the following -*
>>
>> *Your query has the following error(s):*
>> OK FAILED: ParseException line 5:0 cannot recognize input near 'STORED'
>> 'STORED' 'AS' in constant
>> click the *Error Log* tab above for details
>>
>> 1
>>
>> CREATE TABLE temp_xyz as
>>
>> 2
>>
>> SELECT prop1,prop2,prop3,prop4,prop5
>>
>> 3
>>
>> FROM hitdata
>>
>> 4
>>
>> WHERE dateoflog=20130101 and prop1='785-ou'
>>
>> 5
>>
>> STORED AS SEQUENCEFILE;
>>
>> ok failed: parseexception line 5:0 cannot recognize input near 'stored'
>> 'stored' 'as' in constant
>>
>
>
>
> --
> Nitin Pawar
>

Mime
View raw message