hdfs导入mysql出错_我用sqoop从oracle导入数据到hdfs时，总是报 表或视图不存在错误，求解答......

表在oracle，XE数据库实例中已经建好，并且命令中的名字也没有错具体的信息[root@hadoop03bin]#./sqoopimport--connectjdbc:oracle:thin:@192.168.8.100:1521:xe--usernamehadoop--pa...

表在oracle，XE数据库实例中已经建好，并且命令中的名字也没有错

具体的信息

[root@hadoop03 bin]# ./sqoop import --connect jdbc:oracle:thin:@192.168.8.100:1521:xe --username hadoop --password hadoop --table person

15/04/29 01:41:07 INFO manager.SqlManager: Using default fetchSize of 1000

15/04/29 01:41:07 INFO tool.CodeGenTool: Beginning code generation

15/04/29 01:41:07 INFO manager.OracleManager: Time zone has been set to GMT

15/04/29 01:41:07 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM person t WHERE 1=0

15/04/29 01:41:07 ERROR manager.SqlManager: Error executing statement: java.sql.SQLException: ORA-00942: 表或视图不存在

java.sql.SQLException: ORA-00942: 表或视图不存在

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)

at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)

at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)

at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)

at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:830)

at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2391)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2672)

15/04/29 01:41:07 ERROR tool.ImportTool: Encountered IOException running import job:

展开