Sanjay, I use the following:
create table products_bought (....); insert overwrite table products_bought select ... from tableMaster; Thanks and Regards, Sonal On Fri, Mar 5, 2010 at 7:36 PM, Sanjay Sharma <[email protected]>wrote: > Hi, > Am trying to get Create Table ... AS SELECT working in Hive 0.50.0 but > still getting {mismatched input 'AS' expecting EOF} error. > > Jira HIVE-31 patch seems to be present in Hive 0.5.0 so might be something > to do with the syntax . > > Any suggestions on what is the correct syntax or whether it is supposed to > work in 0.5. > > > Regards, > Sanjay > > Impetus Technologies is participating at the CTIA Wireless 2010 from 23rd > to 25th March 2010. Meet Impetus in Las Vegas to experience our mobile and > wireless domain expertise. Click http://impetus.com/events to know more. > > Follow our updates on www.twitter.com/impetuscalling. > > NOTE: This message may contain information that is confidential, > proprietary, privileged or otherwise protected by law. The message is > intended solely for the named addressee. If received in error, please > destroy and notify the sender. Any use of this email is prohibited when > received in error. Impetus does not represent, warrant and/or guarantee, > that the integrity of this communication has been maintained nor that the > communication is free of errors, virus, interception or interference. >
