Hive Hadoop数据迁移工具配置
squirrel Config
Add Driver
NAME:Hive1.2
Example URL:jdbc:hive2://132.228.24.35:8901/cwdsjdb
Website URL:[不填]
Class Name:org.apache.hive.jdbc.HiveDriver
Add Alias
NAME:[随意]
Driver:Hive1.2
URL:[选好Driver会自动填上]
User Name:infa
Password: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';