mysql -->hive
sqoop import --connect jdbc:mysql://192.168.8.91:3306/mysql --username root --password root --table help_topic --fields-terminated-by "," --delete-target-dir --hive-import --create-hive-table --hive-database mysql --hive-table help_topic -m 1
hive --> mysql
sqoop export --connect jdbc:mysql://192.168.8.5:3306/test --username root --password root --table t_emp_mysql --columns "empno,ename,job,mgr,hiredate,sal,comm,deptno" --hcatalog-database test --hcatalog-table t_emp --input-fields-terminated-by '\001'
mysql -->hbase
sqoop import -D sqoop.hbase.add.row.key=true --connect jdbc:mysql://192.168.8.5:3306/test --username root --password root --table emp --columns EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO --hbase-create-table --hbase-table t_emp --column-family info --hbase-row-key EMPNO -m 1