sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From A Laxmi <a.lakshmi...@gmail.com>
Subject Re: sqoop 1.4.4 export issue
Date Wed, 18 Sep 2013 19:06:59 GMT
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.

Mime
View raw message