使用Oracle Loader将HBase数据导入到Oracle表中 [英] using Oracle Loader to import HBase data into Oracle table

问题描述

我在HBase表中有数据，我试图导入到Oracle或MySQL表中。我听说有一个Oracle Loader可以达到目的。

任何人都试图将Hadoop HBase数据导入Oracle表中？如果是这样，请给我一个关于如何做到这一点的参考链接？ 我不知道你是怎么做到的正在这样做。我上次检查时没有支持通过Sqoop从HBase导出到SQL DB 。因为这个事实你正面临这个问题。您可以尝试：

• 将HBase数据导出到HDFS，然后将其导出到Oracle。


• 将HBase表映射到Hive并执行导出。
  

我也不太确定Oracle数据加载器是否支持HBase导出。您可以分享您已阅读过的链接吗？

编辑：

如果您遇到其他工具的问题，您可以使用 DBOutputFormat 。

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?

解决方案

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.

这篇关于使用Oracle Loader将HBase数据导入到Oracle表中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！