Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Sqoop2 Failing with Oracle Connection java.lang.RuntimeException: Could not determine columns

Sqoop2 Failing with Oracle Connection java.lang.RuntimeException: Could not determine columns

New Contributor

 

 

I am trying to run a job which imports from Oracle to HDFS but getting following errors.

 

java.lang.RuntimeException: Could not determine columns in Oracle Table.
at org.apache.sqoop.connector.jdbc.oracle.OracleJdbcCommonInitializer.getSchema(OracleJdbcCommonInitializer.java:140)
at org.apache.sqoop.connector.jdbc.oracle.OracleJdbcCommonInitializer.getSchema(OracleJdbcCommonInitializer.java:48)
at org.apache.sqoop.driver.JobManager.getSchemaForConnector(JobManager.java:529)
at org.apache.sqoop.driver.JobManager.createJobRequest(JobManager.java:426)
at org.apache.sqoop.driver.JobManager.start(JobManager.java:317)
at org.apache.sqoop.handler.JobRequestHandler.startJob(JobRequestHandler.java:353)
at org.apache.sqoop.handler.JobRequestHandler.handleEvent(JobRequestHandler.java:114)
at org.apache.sqoop.server.v1.JobServlet.handlePutRequest(JobServlet.java:84)
at org.apache.sqoop.server.SqoopProtocolServlet.doPut(SqoopProtocolServlet.java:81)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:808)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669)
at org.apache.hadoop.security.authentication.server.AuthenticationFilter.doFilter(AuthenticationFilter.java:594)
at org.apache.hadoop.security.token.delegation.web.DelegationTokenAuthenticationFilter.doFilter(DelegationTokenAuthenticationFilter.java:291)
at org.apache.hadoop.security.authentication.server.AuthenticationFilter.doFilter(AuthenticationFilter.java:553)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
at org.eclipse.jetty.server.Server.handle(Server.java:499)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257)
at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

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.T4CStatement.doOall8(T4CStatement.java:195)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:876)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1498)
at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406)
at org.apache.sqoop.connector.jdbc.oracle.util.OracleQueries.getTableColumns(OracleQueries.java:710)
at org.apache.sqoop.connector.jdbc.oracle.util.OracleQueries.getFromTableColumns(OracleQueries.java:770)
at org.apache.sqoop.connector.jdbc.oracle.util.OracleQueries.getFromTableColumnNames(OracleQueries.java:644)
at org.apache.sqoop.connector.jdbc.oracle.OracleJdbcFromInitializer.getColumnNames(OracleJdbcFromInitializer.java:94)
at org.apache.sqoop.connector.jdbc.oracle.OracleJdbcFromInitializer.getColumnNames(OracleJdbcFromInitializer.java:31)
at org.apache.sqoop.connector.jdbc.oracle.OracleJdbcCommonInitializer.getSchema(OracleJdbcCommonInitializer.java:129)
... 29 more

 

any idea what;s going wrong here. I don't find a clear documentation on this.

 

Thanks,

1 REPLY 1

Re: Sqoop2 Failing with Oracle Connection java.lang.RuntimeException: Could not determine columns

New Contributor

Is there someone who as got this issue?.

Don't have an account?
Coming from Hortonworks? Activate your account here