sqoop import --connect jdbc:oracle:thin:@10.100.100.1:1521/orcl --username oracle --passowrd oracle --query "select * from oracle.sample where \$CONDITIONS and start_date < to_date('1999-10-31','yyyy-MM-dd')" --target-dir '/user/hive/warehouse/test.db/sample/start_date=19990930' -m 1 --delete-target-dir --null-string '\\N' --null-non-string '\\N' --hive-import --hive-database test --hive-table sample --hive-drop-import-delims --hive-partition-key start_date --hive-partition-value 19990930
sqoop导入hive表时,去除列中的tab键回车键等
最新推荐文章于 2023-02-13 16:01:28 发布