Thanks, Venkat! Based on your suggestion and some research, I exported HBase data to HDFS which created a file named 'part-00000'. Could you please suggest how to export HDFS file 'part-00000' into a SQL Database such as MYSQL or ORACLE??


On Fri, Sep 13, 2013 at 4:07 PM, Venkat Ranganathan <vranganathan@hortonworks.com> wrote:
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 table

Venkat



On Fri, Sep 13, 2013 at 12:46 PM, A Laxmi <a.lakshmi458@gmail.com> wrote:

Hi,

 

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

 

Exceptions:

 

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

 

Please help

 



CONFIDENTIALITY NOTICE
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.