Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Sqoop, mail # user - How to export Hbase table to MySQL table?


Copy link to this message
-
Re: How to export Hbase table to MySQL table?
Suhas Satish 2013-09-05, 23:12
Its a good question. Even I'd  like to know the answer.

But from the sqoop documentation site, this may help you speed things up a
bit. It still doesnt avoid the intermediate hive-metadata creation stage.

MySQL provides a direct mode for exports as well, using the mysqlimport tool.
When exporting to MySQL, use the --direct argument to specify this
codepath. This may be higher-performance than the standard JDBC codepath.

Note: When using export in direct mode with MySQL, the MySQL bulk utility
mysqlimport must be available in the shell path of the task process.

On Wed, Sep 4, 2013 at 3:15 AM, Apple Wang <[EMAIL PROTECTED]> wrote:

> exporting Hbase table to mysql table using sqoop, but I find sqoo
Cheers,
Suhas.