oracle到hive缺失精度,从Oracle导入Hive报错：找不到empno列

18/08/15 14:56:33 INFO mapred.JobClient:     SPLIT_RAW_BYTES=87

18/08/15 14:56:33 INFO mapreduce.ImportJobBase: Transferred 374 bytes in 12.4609 seconds (30.0138 bytes/sec)

18/08/15 14:56:33 INFO mapreduce.ImportJobBase: Retrieved 14 records.

18/08/15 14:56:33 INFO manager.OracleManager: Time zone has been set to GMT

18/08/15 14:56:33 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM emp t WHERE 1=0

18/08/15 14:56:33 ERROR util.SqlTypeMap: It seems like you are looking up a column that does not

18/08/15 14:56:33 ERROR util.SqlTypeMap: exist in the table. Please ensure that you've specified

18/08/15 14:56:33 ERROR util.SqlTypeMap: correct column names in Sqoop options.

18/08/15 14:56:33 ERROR tool.ImportTool: Imported Failed: column not found: empno

前面的从Oracle导出应该是成功了，在hdfs里面已经可以找到导出来的emp文件了，但是之后就报错了，报emp列找不到。

./sqoop import --hive-import --connect jdbc:oracle:thin:@.....:1521/orcl --username scott --password tiger --table emp --columns 'empno,ename,job,sal,deptno' -m 1