参考:
Sqoop中文手册
1、列出mysql数据库:
sqoop list-databases --connect jdbc:mysql://192.168.100.13:3306 --username hive --password hive
[root@master sqoop]# sqoop list-databases --connect jdbc:mysql://192.168.100.13:3306/ --username hive --password hive
Warning: /opt/cloudera/parcels/CDH-5.5.0-1.cdh5.5.0.p0.8/bin/../lib/sqoop/../accumulo does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
15/12/08 12:44:24 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6-cdh5.5.0
15/12/08 12:44:24 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
15/12/08 12:44:25 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
information_schema
hive
mysql
test
[root@master sqoop]#
#################
2、列出mysql数据库hive中的表:
sqoop list-tables --connect jdbc:mysql://192.168.100.13:3306/hive --username hive --password hive
##################
3、复制表结构:
mysql数据的表结构复制到hive中,只是复制表的结构,表中的内容没有复制过去。
sqoop create-hive-table --connect jdbc:mysql://192.168.100.13:3306/hive --username hive --password hive \
--table tbl_6005 --hive-table sqoop_test
[root@master sqoop]# sqoop create-hiv
Sqoop中文手册
1、列出mysql数据库:
sqoop list-databases --connect jdbc:mysql://192.168.100.13:3306 --username hive --password hive
[root@master sqoop]# sqoop list-databases --connect jdbc:mysql://192.168.100.13:3306/ --username hive --password hive
Warning: /opt/cloudera/parcels/CDH-5.5.0-1.cdh5.5.0.p0.8/bin/../lib/sqoop/../accumulo does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
15/12/08 12:44:24 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6-cdh5.5.0
15/12/08 12:44:24 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
15/12/08 12:44:25 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
information_schema
hive
mysql
test
[root@master sqoop]#
#################
2、列出mysql数据库hive中的表:
sqoop list-tables --connect jdbc:mysql://192.168.100.13:3306/hive --username hive --password hive
##################
3、复制表结构:
mysql数据的表结构复制到hive中,只是复制表的结构,表中的内容没有复制过去。
sqoop create-hive-table --connect jdbc:mysql://192.168.100.13:3306/hive --username hive --password hive \
--table tbl_6005 --hive-table sqoop_test
[root@master sqoop]# sqoop create-hiv