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]<mailto:[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]<mailto:[email protected]> P: 702-407-0707 ext. 8947 D: 702-835-8947 F: 702-492-9871
