Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

sqoop to bucketed hive table

sqoop to bucketed hive table

New Contributor

All,

I have created hive table with 26 bucket, I need to import data from the SQL .

early 2015 , there is no support for this requirement. ( http://grokbase.com/t/sqoop/user/14ccggfpvv/sqooping-to-a-bucketed-hive-table )

Want to know, update on this. or any work around?

any help ?

1 REPLY 1

Re: sqoop to bucketed hive table

Cloudera Employee

Hi Gobi,

Based on the following Jira, unfortunately, it seems like the ability to import directly into hive bucketed tables is not supported yet.

https://issues.apache.org/jira/browse/SQOOP-1889

So you would have to import the data to an intermediate table and then insert into the bucketed table.

Thanks

Venkata