file this one under RTFM.
On Wed, Feb 5, 2014 at 9:11 AM, Nitin Pawar <nitinpawar...@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 <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 >
