hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jay Ramadorai <jramado...@tripadvisor.com>
Subject Loading data into a Clustered/bucketed table
Date Mon, 07 Mar 2011 23:01:23 GMT
I am Sqooping data from an external source into a bucketed Hive table. Sqoop seems completely
bucket-unaware, it simply used LOAD INPATH which moves the single file containing Sqooped
data into the Hive warehouse location.

My question: 
- is there any way to get data into an empty clustered/bucketed table other than to first
get the data into a temp table and the INSERT OVERWRITE SELECT from it? 
- Can INSERT OVERWRITE take its input from STDIN or a file instead of a Hive table?

thanks
Jay
Mime
View raw message