Can you post your query? It should work like
create table T as select a, b+1 b1, c*2 c2 from S where ...
You don't need to specify the schema of T cause it is derived from the
select-clause. T's column's name is the same as the alias name in the
select-clause.
Thanks,
Ning
On Mar 5, 2010, at 6:06 AM, Sanjay Sharma 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.
