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 < [email protected]> 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 <[email protected]> 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.
