sqoop导入到配置单元表错误(sqoop import to hive table error)

 您好，我尝试将as400表插入到配置单元表中，因此我创建了一个具有as400表的相同架构的配置单元表，但我添加了一个已处理的列（时间戳），这是我的配置单元表： 
 
CREATE external TABLE IF NOT EXISTS default.AS400TEST (
One INT,
Two STRING,
..
N   INT             
)
PARTITIONED BY (processedate TIMESTAMP)
STORED AS  TEXTFILE 
location  '/tmp/AS400TEST;
 
 我运行这个sqoop命令： 
 
sqoop import --verbose --driver $DRIVER_CLASS --connect $URL --username $LOGIN --password $PASSWORD \
--table $TABLE \
--target-dir $DIR \
-m 1 --hive-import --hive-table default.AS400TEST \
--hive-partition-key "processedate"
 
 我的问题是，地图保持在0％以上超过30分钟，我杀了这份工作。 我需要改变什么吗？ 
 
 另一个问题：如何在sqoop中插入列时间戳？ 

Hello i try to insert as400 table to hive table, so i create a hive table with the same schema of the as400 table but i add a columns processedate (timestamp) this is my hive table: 
 
CREATE external TABLE IF NOT EXISTS default.AS400TEST (
One INT,
Two STRING,
..
N   INT             
)
PARTITIONED BY (processedate TIMESTAMP)
STORED AS  TEXTFILE 
location  '/tmp/AS400TEST;
 
I run this sqoop command:
 
sqoop import --verbose --driver $DRIVER_CLASS --connect $URL --username $LOGIN --password $PASSWORD \
--table $TABLE \
--target-dir $DIR \
-m 1 --hive-import --hive-table default.AS400TEST \
--hive-partition-key "processedate"
 
My problem is that the map remains on 0% for more than 30 min and i kill the job. did i need to change Something?
 
Another question: how to insert the column timestamp with sqoop?

原文：https://stackoverflow.com/questions/50064569