using Oracle Loader to import HBase data into Orac

Question

I have data in HBase table that I am trying to import into an Oracle or a MySQL table. I heard there is an Oracle Loader that can server the purpose.

Anyone tried to import Hadoop HBase data into an Oracle table? If so, could you please give me a reference link on how I can do that?

Answer 1

I don't know how you are doing this. Last time I had checked there was no support for export from HBase to SQL DBs through Sqoop. You are facing this issue because of this fact. You could probably try :

• Exporting HBase data to HDFS and then export it to Oracle.
• Mapping HBase tables to Hive and do the export.

I'm also not very sure if Oracle data loader supports HBase exports. Could you please share the link where you have read about this?

Edit :

If you are facing issues with other tools, you could probably make use of DBOutputFormat.