Hi Abraham, Thanks for your quick response. Yes I do have all the privileges.
Regards Jay Thanks Jay On Wed, Jul 15, 2015 at 4:47 PM, Abraham Elmahrek <[email protected]> wrote: > Hey man, > > Try with --verbose option. Make sure you have the following privileges: > http://sqoop.apache.org/docs/1.4.6/SqoopUserGuide.html#_additional_oracle_roles_and_privileges_required_for_export > . > > On Wed, Jul 15, 2015 at 4:35 PM, Kumar Jayapal <[email protected]> > wrote: > >> Hi, >> >> I see the table in my database. When I execute a export command I get >> table or view does not exist. When I do list-tables I can see the table. >> >> Can some one tell me what wrong. I have DBA privileges >> >> sqoop export --connect "jdbc:oracle:thin:@lorsasa.ss.com:1521/pocd01us" >> --username " TESTUSER" --P --table "TEST_DIMENSION" --export-dir >> "/user/hive/warehouse/test.db/test_dimension/" >> Warning: >> /opt/cloudera/parcels/CDH-5.3.2-1.cdh5.3.2.p654.326/bin/../lib/sqoop/../accumulo >> does not exist! Accumulo imports will fail. >> Please set $ACCUMULO_HOME to the root of your Accumulo installation. >> 15/07/15 23:20:03 INFO sqoop.Sqoop: Running Sqoop version: 1.4.5-cdh5.3.2 >> Enter password: >> 15/07/15 23:20:20 INFO oracle.OraOopManagerFactory: Data Connector for >> Oracle and Hadoop is disabled. >> 15/07/15 23:20:20 INFO manager.SqlManager: Using default fetchSize of 1000 >> 15/07/15 23:20:20 INFO tool.CodeGenTool: Beginning code generation >> 15/07/15 23:20:21 INFO manager.OracleManager: Time zone has been set to >> GMT >> 15/07/15 23:20:21 INFO manager.SqlManager: Executing SQL statement: >> SELECT t.* FROM TEST_DIMENSION t WHERE 1=0 >> 15/07/15 23:20:21 ERROR manager.SqlManager: Error executing statement: >> java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist >> >> java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist >> >> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447) >> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) >> at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951) >> at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513) >> at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227) >> at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) >> at >> oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208) >> at >> oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:886) >> at >> oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175) >> at >> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296) >> at >> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613) >> at >> oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3657) >> at >> oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495) >> at >> org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:750) >> at >> org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:759) >> at >> org.apache.sqoop.manager.SqlManager.getColumnInfoForRawQuery(SqlManager.java:269) >> at >> org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:240) >> at >> org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:226) >> at >> org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:295) >> at >> org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1833) >> at >> org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1645) >> at >> org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:96) >> at >> org.apache.sqoop.tool.ExportTool.exportTable(ExportTool.java:64) >> at org.apache.sqoop.tool.ExportTool.run(ExportTool.java:100) >> at org.apache.sqoop.Sqoop.run(Sqoop.java:143) >> at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) >> at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179) >> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:218) >> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:227) >> at org.apache.sqoop.Sqoop.main(Sqoop.java:236) >> 15/07/15 23:20:21 ERROR tool.ExportTool: Encountered IOException running >> export job: java.io.IOException: No columns to generate for ClassWriter >> >> >> >> >> >> Thanks >> Jay >> > >
