SQOOP抽取各类型数据库脚本示例

------------MySQL------------

导入到HDFS

sqoop import --connect jdbc:mysql://localhost:3306/wht --username root --password cloudera --table people --fields-terminated-by &＃39;,&＃39; --target-dir /user/hive/warehouse/cust --delete-target-dir --null-string &＃39;&＃39; --null-non-string &＃39;&＃39;   -m 1



导入到Hive

sqoop import --connect jdbc:mysql://localhost:3306/wht --username root --password cloudera --table people --fields-terminated-by &＃39;,&＃39;  --hive-import --hive-table db01.peopleseq --hive-overwrite  -m 1



---------------ORACLE------------



导入到HDFS

sqoop import --connect jdbc:oracle:thin:&＃64;192.168.20.104:1521:xe --username dep --password Dep2018 --table WHT_C --fields-terminated-by &＃39;\001&＃39; --target-dir /user/hive/warehouse/oracledb/wht_c  --delete-target-dir -m 1





导入到Hive

sqoop import --hive-import --connect jdbc:oracle:thin:&＃64;192.168.20.104:1521:xe --username dep --password Dep2018 --table WHT_C --hive-database  oracledb --hive-table wht_c --fields-terminated-by &＃39;\001&＃39; --hive-overwrite  -m 1



------------DB2------------

导入到HDFS

sqoop import --connect jdbc:db2://192.168.20.104:60000/dep --username db2inst1 --password Server2008! --table wht_test  --fields-terminated-by &＃39;\001&＃39; --target-dir --delete-target-dir   /user/hive/warehouse/db2db/wht_test  -m 1



sqoop import --hive-import --connect jdbc:db2://192.168.20.104:60000/dep --username db2inst1 --password Server2008! --table wht_test --hive-database  db2db --hive-table wht_test --fields-terminated-by &＃39;\001&＃39; --hive-overwrite  -m 1



------------SQL SERVER------------

导入到HDFS

sqoop import --connect &＃39;jdbc:sqlserver://192.168.20.105:1433;databasename&＃61;dep&＃39; --username sa --password Server2008!  --table wht_b --fields-terminated-by &＃39;\001&＃39; --target-dir /user/hive/warehouse/sqlserverdb/wht_b1  --delete-target-dir  -m 1



导入到Hive

sqoop import --hive-import --connect &＃39;jdbc:sqlserver://192.168.20.105:1433;databasename&＃61;dep&＃39; --username sa --password Server2008!  --table wht_b --hive-database  sqlserverdb --hive-table wht_b  --fields-terminated-by &＃39;\001&＃39; --hive-overwrite  -m 1



-------------PG------------

导入到HDFS

sqoop import --connect  jdbc:postgresql://192.168.20.104:5432/wht --username postgres --password Server2008!  --table wht_a --fields-terminated-by &＃39;\t&＃39; --target-dir /user/hive/warehouse/pgdb/wht_a  --delete-target-dir -m 1



导入到Hive

sqoop import --hive-import --connect  jdbc:postgresql://192.168.20.104:5432/wht --username postgres --password Server2008!  --table wht_a   --hive-database  pgdb --hive-table wht_a  --fields-terminated-by &＃39;\t&＃39; --hive-overwrite  -m 1