search

Home  >  Article  >  Database  >  sqoop导入hbase

sqoop导入hbase

WBOY
WBOYOriginal
2016-06-07 16:41:271475browse

list-tables sqoop list-tables --connect jdbc:mysql://192.168.40.194/sqoop --username root --password=root 建表及数据导入 sqoop import --connect jdbc:oracle:thin:@69.16.22.106:1521:tjsatbi --table FWSK.DM_HY --username SJCX --password sjcx

list-tables

<code>sqoop list-tables --connect jdbc:mysql://192.168.40.194/sqoop --username root --password=root
</code>

建表及数据导入

<code>sqoop import --connect jdbc:oracle:thin:@69.16.22.106:1521:tjsatbi --table FWSK.DM_HY --username SJCX --password sjcx --column-family cf --hbase-create-table --hbase-table sqoop_hy --hbase-row-key HY_DM --verbose -m 1
</code>

增量导入

<code>sqoop import --connect jdbc:oracle:thin:@69.16.22.106:1521:tjsatbi --table FWSK.DM_HY --username SJCX --password sjcx --column-family cf --hbase-table sqoop_hy --hbase-row-key HY_DM --incremental append --check-column HY_DM --last-value 9900 --verbose -m 1
</code>

原文地址：sqoop导入hbase, 感谢原作者分享。

Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：HDFS snapshot操作实战Next article：CentOS 6.4系统MySQL主从复制基本配置实践

Related articles

See more