[
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)
