                        課程
                    
                        /云計算&大數據
                        
                            /大數據
                        
                        /走近大數據之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?