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