sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rakesh Varma (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (SQOOP-2885) Oracle table import failing with GENERIC_JDBC_CONNECTOR_0005:No column is found to partition data
Date Thu, 17 Mar 2016 06:37:33 GMT

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

Mime
View raw message