Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Hive Query Error


Copy link to this message
-
Re: Hive Query Error
file this one under RTFM.
On Wed, Feb 5, 2014 at 9:11 AM, Nitin Pawar <[EMAIL PROTECTED]> wrote:

> its create table xyz stored as sequencefile as select blah from table
>
>
> On Wed, Feb 5, 2014 at 10:37 PM, Raj Hadoop <[EMAIL PROTECTED]> 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
>