出错原句为:
sqoop import --connect jdbc:mysql://192.168.56.111:3306/test --driver com.mysql.jdbc.Driver --query "select * from orders where orddate = '2020-11-10' and $CONDITIONS" --username root --password root --delete-target-dir --hive-import --hive-database default --hive-table orderinfos --hive-partition-key 'orddate' --hive-partition-value '20201110' --target-dir /mytmp/orderinfos -m 1
原因:
orddate column is present in your SQLServer table.
+-------+------------+
| ordid | orddate |
+-------+------------+
| 1 | 2020-11-10 |
+-------+------------+
修改字段名字: alter table orders change orddate orderdate date not null ;
sqoop import --connect jdbc:mysql://192.168.56.111:3306/test --driver com.mysql.jdbc.Driver --query "select * from orders where orderdate = '2020-11-10' and $CONDITIONS" --username root --password root --delete-target-dir --hive-import --hive-database default --hive-table orderinfos --hive-partition-key 'orddate' --hive-partition-value '20201110' --target-dir /mytmp/orderinfos -m 1