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 ?
Based on the following Jira, unfortunately, it seems like the ability to import directly into hive bucketed tables is not supported yet.
So you would have to import the data to an intermediate table and then insert into the bucketed table.