Uploaded image for project: 'Sqoop'
  1. Sqoop
  2. SQOOP-2885

Oracle table import failing with GENERIC_JDBC_CONNECTOR_0005:No column is found to partition data

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 1.99.6
    • Fix Version/s: None
    • Labels:
      None
    • 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

      Description

      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)

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              varma.rakesh@gmail.com Rakesh Varma
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: