Welcome to the Cloudera Community

Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Who agreed with this topic

My question is about sqoop export between hbase and mysql!

avatar
New Contributor

I want to export data from Hbase into Mysql database. So I use sqoop to do this job.

First I export hbase into a folder. The command is "hbase org.apache.hadoop.hbase.mapreduce.Driver export h_small /tmp/dfsmall".

The next command is "sqoop export --connect jdbc:mysql://192.168.0.132:3306/test --username apps --password apps --table from_h_page_template --export-dir /tmp/dfsmall --input-fields-terminated-by '\001' --columns id,name,pid".

Now exception is showed. The exception is "java.lang.RuntimeException: java.io.IOException: WritableName can't load class: org.apache.hadoop.hbase.io.ImmutableBytesWritable".

 

What is wrong? My CDH version is 5.1

Who agreed with this topic