squirrel Config
Add DriverNAME:Hive1.2Example URL:jdbc:hive2://132.228.24.35:8901/cwdsjdbWebsite URL:[不填]Class Name:org.apache.hive.jdbc.HiveDriver
Add AliasNAME:[随意]Driver:Hive1.2URL:[选好Driver会自动填上]User Name:infaPassword:infa
进入目录后(cd /home/infa/sqoop/bin)LINUX指令: ./sqoop import --connect jdbc:oracle:thin:@132.228.209.7:1521:TMSDB3 --username MSS_CWDT --password 'msscw_411' --hive-import --hive-database cwdsjdb --table P_V_FI_ASSET_LIST --null-string '\\N' --null-non-string '\\N' --hive-drop-import-delims --m 1./sqoop export --connect jdbc:oracle:thin:@132.228.26.169:1621:cwgldb2 --username CWDSJ --password '!cwdsj16' --export-dir /user/hive/warehouse/cwdsjdb.db/mss_dsjzc_mxhz1 --table MSS_DSJZC_MXHZ1 --input-fields-terminated-by '\001' --input-lines-terminated-by '\n' --input-null-string '\\N' --input-null-non-string '\\N';./sqoop export --connect jdbc:oracle:thin:@132.228.26.169:1621:cwgldb2 --username CWDSJ --password '!cwdsj16' --export-dir /user/hive/warehouse/cwdsjdb.db/mss_dsjzc_khhz1 --table MSS_DSJZC_KHHZ1 --input-fields-terminated-by '\001' --input-lines-terminated-by '\n' --input-null-string '\\N' --input-null-non-string '\\N';./sqoop export --connect jdbc:oracle:thin:@132.228.26.169:1621:cwgldb2 --username CWDSJ --password '!cwdsj16' --export-dir /user/hive/warehouse/cwdsjdb.db/mss_dsjzc_xzhz1 --table MSS_DSJZC_XZHZ1 --input-fields-terminated-by '\001' --input-lines-terminated-by '\n' --input-null-string '\\N' --input-null-non-string '\\N';./sqoop export --connect jdbc:oracle:thin:@132.228.26.169:1621:cwgldb2 --username CWDSJ --password '!cwdsj16' --export-dir /user/hive/warehouse/cwdsjdb.db/mss_dsjzc_cxlhz --table MSS_DSJZC_CXLHZ --input-fields-terminated-by '\001' --input-lines-terminated-by '\n' --input-null-string '\\N' --input-null-non-string '\\N';
转载于:https://www.cnblogs.com/Dream-Lasting/p/8991089.html
相关资源：JAVA上百实例源码以及开源项目