sqoop报错之 ERROR tool.ImportTool: Import failed: Partition key orddate cannot be a column to import.

出错原句为：

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