将HBase表导出到mysql
我使用hbase-0.90.6。我想将数据从HBase导出到mysql。我知道两步过程,首先通过运行mapreduce作业将Hbase数据拉入平面文件,然后将平面文件数据导入到mysql中。
I am using hbase-0.90.6. I want to export the data from HBase to mysql. I know two-step process , first by running a mapreduce job to pull Hbase data into flat files, then exports flat file data into mysql.
是他们的其他工具我可以用这两步来减少这一步。或者我们可以使用sqoop在一个步骤中执行相同的操作。谢谢。
Is their any other tool which I can use to reduce this two-step to one. Or can we use sqoop to do the same in one step. Thanks.
恐怕Sqoop目前不支持直接从HBase导出。 Sqoop可以通过第二步在两步过程中为您提供帮助 - 例如Sqoop可以从HDFS获取数据并将其导出到MySQL。
I'm afraid that Sqoop do not support exports directly from HBase at the moment. Sqoop can help you in the two-step process with the second step - e.g. Sqoop can take data from HDFS and export them to MySQL.