hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stephen Boesch <java...@gmail.com>
Subject How to use create .. as select
Date Thu, 29 Mar 2012 17:15:13 GMT
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'
'demographics_local' '.' in create table statement

I tried some variants on the above  with similar results:

hive> insert overwrite table dem select * from demographics_local;
FAILED: Error in semantic analysis: Line 1:23 Table not found 'dem'


If i create the target table first, then things are ok.  But is that
necessary?

hive> create table dem(uid int, age string, gender string, dlocation string,
    > children string, home_market_value string, home_owner_status string,
home_property_type string,
    > household_income string, length_of_residence string, marital_status
string)
    > ;
OK
hive> insert overwrite table dem select * from
demographics_local;
Total MapReduce jobs = 2
Launching Job 1 out of 2
...
Table default.dem stats: [num_partitions: 0, num_files: 1, num_rows: 0,
total_size: 9946167, raw_data_size: 0]
301399 Rows loaded to dem
OK

Mime
View raw message