Sqoop cannot directly export from a hbase table. The Hcatalog integration can be used, but you have to create an external table in Hive accessing the hbase table and then use Sqoop HCat support to export the tableVenkat
On Fri, Sep 13, 2013 at 12:46 PM, A Laxmi <email@example.com> wrote:
I installed sqoop 1.4.4. I have data in HBase that I would like to export it to a MySQL database. I used the following export command but it throws exceptions.
Sqoop export Command used:
sudo bin/export –connect jdbc:mysql://xxx.xxx.x.xx:3306/ --table webpage –username xxxx –password xxxxxxxx –export –dir /var/hbase/hbase-data-dir/webpage
Error manager.SqlManager: Error executing statement: java.sqlException: Unknown initial character set index ‘224’ received from server.
Error tool.ExportTool: Encounteres IOException running export job: java.io.IOException: No columns to generate fro ClassWriter
NOTICE: This message is intended for the use of the individual or entity to which it is addressed and may contain information that is confidential, privileged and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, you are hereby notified that any printing, copying, dissemination, distribution, disclosure or forwarding of this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately and delete it from your system. Thank You.