You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by "Rakesh Varma (JIRA)" <ji...@apache.org> on 2016/03/17 07:37:33 UTC
[jira] [Updated] (SQOOP-2885) Oracle table import failing with
GENERIC_JDBC_CONNECTOR_0005:No column is found to partition data
[ https://issues.apache.org/jira/browse/SQOOP-2885?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rakesh Varma updated SQOOP-2885:
--------------------------------
Environment:
java version "1.7.0_80"
Ubuntu 14.04.2 LTS
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit
hadoop 2.7.1
was:
java version "1.7.0_80"
Ubuntu 14.04.2 LTS
> Oracle table import failing with GENERIC_JDBC_CONNECTOR_0005:No column is found to partition data
> --------------------------------------------------------------------------------------------------
>
> Key: SQOOP-2885
> URL: https://issues.apache.org/jira/browse/SQOOP-2885
> Project: Sqoop
> Issue Type: Bug
> Components: connectors/generic, connectors/oracle
> Affects Versions: 1.99.6
> Environment: java version "1.7.0_80"
> Ubuntu 14.04.2 LTS
> Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit
> hadoop 2.7.1
> Reporter: Rakesh Varma
> Priority: Minor
>
> Created links and job thru the command line client.
> These are the connector details
> from connector = 4
> to connector = 3
> During the job creation, I did not specify anything for partition column
> Table SQL statement:
> Table column names:
> Partition column name:
> Null value allowed for the partition column:
> The job is getting successfully created. But when I start it is failing with this error below.
> However, when i specify a partition column, it is working fine.
> Caused by: Exception: org.apache.sqoop.common.SqoopException Message: GENERIC_JDBC_CONNECTOR_0005:No column is found to partition data -
> Stack trace:
> at org.apache.sqoop.connector.jdbc.GenericJdbcFromInitializer (GenericJdbcFromInitializer.java:144)
> at org.apache.sqoop.connector.jdbc.GenericJdbcFromInitializer (GenericJdbcFromInitializer.java:53)
> at org.apache.sqoop.connector.jdbc.GenericJdbcFromInitializer (GenericJdbcFromInitializer.java:41)
> at org.apache.sqoop.driver.JobManager (JobManager.java:449)
> at org.apache.sqoop.driver.JobManager (JobManager.java:372)
> at org.apache.sqoop.driver.JobManager (JobManager.java:276)
> at org.apache.sqoop.handler.JobRequestHandler (JobRequestHandler.java:380)
> at org.apache.sqoop.handler.JobRequestHandler (JobRequestHandler.java:116)
> at org.apache.sqoop.server.v1.JobServlet (JobServlet.java:96)
> at org.apache.sqoop.server.SqoopProtocolServlet (SqoopProtocolServlet.java:79)
> at javax.servlet.http.HttpServlet (HttpServlet.java:646)
> at javax.servlet.http.HttpServlet (HttpServlet.java:723)
> at org.apache.catalina.core.ApplicationFilterChain (ApplicationFilterChain.java:290)
> at org.apache.catalina.core.ApplicationFilterChain (ApplicationFilterChain.java:206)
> at org.apache.hadoop.security.authentication.server.AuthenticationFilter (AuthenticationFilter.java:595)
> at org.apache.hadoop.security.token.delegation.web.DelegationTokenAuthenticationFilter (DelegationTokenAuthenticationFilter.java:291)
> at org.apache.hadoop.security.authentication.server.AuthenticationFilter (AuthenticationFilter.java:554)
> at org.apache.catalina.core.ApplicationFilterChain (ApplicationFilterChain.java:235)
> at org.apache.catalina.core.ApplicationFilterChain (ApplicationFilterChain.java:206)
> at org.apache.catalina.core.StandardWrapperValve (StandardWrapperValve.java:233)
> at org.apache.catalina.core.StandardContextValve (StandardContextValve.java:191)
> at org.apache.catalina.core.StandardHostValve (StandardHostValve.java:127)
> at org.apache.catalina.valves.ErrorReportValve (ErrorReportValve.java:103)
> at org.apache.catalina.core.StandardEngineValve (StandardEngineValve.java:109)
> at org.apache.catalina.connector.CoyoteAdapter (CoyoteAdapter.java:293)
> at org.apache.coyote.http11.Http11Processor (Http11Processor.java:861)
> at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler (Http11Protocol.java:606)
> at org.apache.tomcat.util.net.JIoEndpoint$Worker (JIoEndpoint.java:489)
> at java.lang.Thread (Thread.java:745)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)