Rakesh Varma Kalidindi created SQOOP-2885:
---------------------------------------------
Summary: 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
Reporter: Rakesh Varma Kalidindi
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)
