Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
>

 
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB