Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - How to use create .. as select


Copy link to this message
-
How to use create .. as select
Stephen Boesch 2012-03-29, 17:15
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