Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Sqoop >> mail # user >> sqoop 1.99.2 import error

Job with id 14 and name myJob2 (Created 7/25/13 7:59 PM, Updated 7/25/13
8:10 PM)
Using Connection id 10 and Connector id 1
  Database configuration
    Schema name: movies
    Table name: Movie
    Table SQL statement:
    Table column names:
    Partition column name:
    Boundary query:
  Output configuration
    Storage type: HDFS
    Output format: SEQUENCE_FILE
    Output directory: /user/kostas/movies
  Throttling resources
sqoop:000> submission start --jid 14
Exception has occurred during processing command
Server has returned exception: Exception: java.lang.Throwable Message:
GENERIC_JDBC_CONNECTOR_0005:No column is found to partition data
Stack trace:
 at  org.apache.sqoop.connector.jdbc.GenericJdbcImportInitializer
 at  org.apache.sqoop.connector.jdbc.GenericJdbcImportInitializer
 at  org.apache.sqoop.connector.jdbc.GenericJdbcImportInitializer
 at  org.apache.sqoop.framework.FrameworkManager
 at  org.apache.sqoop.handler.SubmissionRequestHandler
 at  org.apache.sqoop.handler.SubmissionRequestHandler
 at  org.apache.sqoop.handler.SubmissionRequestHandler
 at  org.apache.sqoop.server.v1.SubmissionServlet
 at  org.apache.sqoop.server.SqoopProtocolServlet
 at  javax.servlet.http.HttpServlet (HttpServlet.java:637)
 at  javax.servlet.http.HttpServlet (HttpServlet.java:717)
 at  org.apache.catalina.core.ApplicationFilterChain
 at  org.apache.catalina.core.ApplicationFilterChain
 at  org.apache.catalina.core.StandardWrapperValve
 at  org.apache.catalina.core.StandardContextValve
 at  org.apache.catalina.core.StandardHostValve
 at  org.apache.catalina.valves.ErrorReportValve
 at  org.apache.catalina.core.StandardEngineValve
 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
 at  org.apache.tomcat.util.net.JIoEndpoint$Worker (JIoEndpoint.java:489)
 at  java.lang.Thread (Thread.java:724)

On Thu, Jul 25, 2013 at 8:06 PM, Mengwei Ding <[EMAIL PROTECTED]>wrote:

> Hi Konstantinos,
> Could you kindly provide more information for better diagnose?
> First, please enter the follow command in sqoop2 command line
> *set option --name verbose --value true*
> and restart your job and then paste the full stack trace.
> Second, could you please show us your job configuration? Please execute
> show job --jid <job_id> --all
> On Thu, Jul 25, 2013 at 9:58 AM, Κωνσταντίνος Αρετάκης <
>> Hi all,
>> I try import a table from mysql to HDFS and I get this error
>> org.apache.sqoop.common.SqoopException: GENERIC_JDBC_CONNECTOR_0005:No
>> column is found to partition data
>> Please help.
>> Thanks