Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Sqoop >> mail # user >> exporting data from sequence files back into an RDBMS


Copy link to this message
-
Re: exporting data from sequence files back into an RDBMS
Eric,

The middle command seems right. Could you provide the rest of your logs? It
will help us understand where in the process sqoop fails.

-Abe
On Wed, Jul 24, 2013 at 3:28 PM, Eric Hernandez <
[EMAIL PROTECTED]> wrote:

> I have tried many different variations all with the same result
>
> sqoop export --connect 'jdbc:mysql://mysqlIP:3306/hadoop'
> --username=hadoop --password='sanitized' --table=tableA --export-dir
> /hive/tableA -m 1 --fields-terminated-by '\001'
>
> sqoop export --connect 'jdbc:mysql://mysqlIP:3306/hadoop'
> --username=hadoop --password='sanitized' --table=tableA --export-dir
> /hive/tableA -m 1 --input-fields-terminated-by  '\001'
>
> sqoop export --connect 'jdbc:mysql://mysqlIP:3306/hadoop'
> --username=hadoop --password='sanitized' --table=tableA --export-dir
> /hive/tableA -m 1
>
>
>
>
>
> Hey Eric,
>
> I believe its possible. Can you provide the command you are using?
>
> -Abe
>
>
> On Wed, Jul 24, 2013 at 2:54 PM, Eric Hernandez <
> [EMAIL PROTECTED]> wrote:
>
>> Hi,
>> Is it possible to sqoop data out of hive back into an RDBMS like MyQL or
>> SQL Server when it has been imported via sqoop as a sequence file?
>>
>> I have been trying all day to get data back out of hive and I keep
>> getting this error no matter what I try
>>
>> "java.lang.ClassCastException: org.apache.hadoop.io.BytesWritable cannot
>> be cast to org.apache.hadoop.io.LongWritable"
>>
>> I am using Sqoop 1.4.1-cdh4.1.2
>>
>> Thanks,
>>
>>  Eric H
>>
>
>
> Eric Hernandez
> Database Administrator
>
> Selling Source, LLC
> Marketing.  Technology.  Data.
> [EMAIL PROTECTED]
> P: 702-407-0707 ext. 8947
> D: 702-835-8947
> F: 702-492-9871
>
>