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

Switch to Plain View
Hive, mail # user - Hive Query Error


+
Raj Hadoop 2014-02-05, 17:08
Copy link to this message
-
Re: Hive Query Error
Nitin Pawar 2014-02-05, 17:12
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

 
+
Stephen Sprague 2014-02-05, 21:15