Re: How to use create .. as select

; Regards > Bejoy KS > -- > *From:* Stephen Boesch > *To:* user@hive.apache.org > *Sent:* Thursday, March 29, 2012 10:45 PM > *Subject:* How to use create .. as select > > I see hive-31 supposedly supports this, but when mimicking the syntax in > the

Re: How to use create .. as select

Thanks v much Edward, I am looking at those resources now. The queries in clientpositive are quite instructive. Here is the correct way to do it so it seems hive> create table dem2 like demographics_local; OK Time taken: 0.188 seconds hive> hive> insert overwrite table dem2 select * from demogra

Re: How to use create .. as select

Hi Stephen       You are missing AS in your statement, try this out Create table dem AS select *  from demographics_local;  Regards Bejoy KS From: Stephen Boesch To: user@hive.apache.org Sent: Thursday, March 29, 2012 10:45 PM Subject: How to use create .. as

Re: How to use create .. as select

You really do not want to mimic the syntax in Jira. In jira the issue bounces back and forth and people are fairly loose in describing syntax. You want to use the hive language manual https://cwiki.apache.org/confluence/display/Hive/LanguageManual Or if you are are feeling brave look in the clien

How to use create .. as select

I see hive-31 supposedly supports this, but when mimicking the syntax in the jira i get errors https://issues.apache.org/jira/browse/HIVE-31 hive> create table dem select demographics_local.* from demographics_local; FAILED: Parse Error: line 1:19 cannot recognize input near 'select' 'demograp