20,808
社区成员
发帖
与我相关
我的任务
分享
sqoop import --connect jdbc:mysql://localhost:3306/source_data?charset-utf8 --username root --password 1 --table VOUCHER_DETAIL --delete-target-dir -m 1 --hive-import --hive-database DATA_PROCESSING --hive-table SQOOP_VOUCHER_TABLE --hive-drop-import-delims --null-string 'NULL' --null-non-string 'NULL' --hive-overwrite -fields-terminated-by '\t'
args = new String[]{
"--connect", String.format("jdbc:mysql://%s/%s?charset-utf8", dataBaseUri, dataBaseName),
"--username", "root",
"--password", pwd,
"--table", tableName,
"-m", mdNum.toString(),
"--hive-import",
"--target-dir", "/user/hive/warehouse/data_processing.db/SQOOP_VOUCHER_TABLE",
"--delete-target-dir",
"--hive-database", "data_processing",
"--create-hive-table",
"--hive-table", "SQOOP_VOUCHER_TABLE",
"--hive-drop-import-delims",
"--null-string", "NULL",
"--null-non-string", "NULL",
"--hive-overwrite",
"--fields-terminated-by", "\\t",
};