[jira] [Created] (SQOOP-780) Sqoop2: GENERIC_JDBC_CONNECTOR_0011:The type is not supported - 2

["Cheolsoo Park (JIRA)" <ji...@apache.org>]

Cheolsoo Park created SQOOP-780:
-----------------------------------

             Summary: Sqoop2: GENERIC_JDBC_CONNECTOR_0011:The type is not supported - 2
                 Key: SQOOP-780
                 URL: https://issues.apache.org/jira/browse/SQOOP-780
             Project: Sqoop
          Issue Type: Bug
    Affects Versions: 1.99.1
            Reporter: Cheolsoo Park
             Fix For: 1.99.1


I created a table in Oracle as follows:
{code}
create table foo (i integer, c varchar(10), primary key (i));
{code}
I get the following error when submitting a job:
{code}
sqoop:000> show job  -a                     
2 job(s) to show: 
Job with id 4 and name: j1
  Database configuration
    Table name: foo
    Table SQL statement: 
    Table column names: 
    Partition column name: i
    Boundary query: 
  Output configuration
    Storage type: HDFS
    Output format: TEXT_FILE
    Output directory: foo
  Throttling resources
    Extractors: 
    Loaders: 
Job with id 5 and name: j2
  Database configuration
    Table name: foo
    Table SQL statement: 
    Table column names: 
    Partition column name: 
    Boundary query: 
  Output configuration
    Storage type: HDFS
    Output format: TEXT_FILE
    Output directory: foo
  Throttling resources
    Extractors: 
    Loaders: 

sqoop:000> submission start --jid 4              
Submission details
Job id: 4
Status: FAILURE_ON_SUBMIT 
Creation date: 2012-25-14 18:25:58 PST
Last update date: 2012-25-14 18:25:58 PST
Exception: org.apache.sqoop.common.SqoopException: GENERIC_JDBC_CONNECTOR_0011:The type is not supported - 2
Stack trace: org.apache.sqoop.common.SqoopException: GENERIC_JDBC_CONNECTOR_0011:The type is not supported - 2
	at org.apache.sqoop.connector.jdbc.GenericJdbcImportPartitioner.getPartitions(GenericJdbcImportPartitioner.java:86)
	at org.apache.sqoop.job.mr.SqoopInputFormat.getSplits(SqoopInputFormat.java:69)
	at org.apache.hadoop.mapreduce.JobSubmitter.writeNewSplits(JobSubmitter.java:455)
	at org.apache.hadoop.mapreduce.JobSubmitter.writeSplits(JobSubmitter.java:472)
	at org.apache.hadoop.mapreduce.JobSubmitter.submitJobInternal(JobSubmitter.java:365)
	at org.apache.hadoop.mapreduce.Job$11.run(Job.java:1216)
	at org.apache.hadoop.mapreduce.Job$11.run(Job.java:1213)
	at java.security.AccessController.doPrivileged(Native Method)
	at javax.security.auth.Subject.doAs(Subject.java:396)
	at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1332)
	at org.apache.hadoop.mapreduce.Job.submit(Job.java:1213)
	at org.apache.sqoop.submission.mapreduce.MapreduceSubmissionEngine.submit(MapreduceSubmissionEngine.java:230)
	at org.apache.sqoop.framework.FrameworkManager.submit(FrameworkManager.java:424)
	at org.apache.sqoop.handler.SubmissionRequestHandler.submissionSubmit(SubmissionRequestHandler.java:112)
	at org.apache.sqoop.handler.SubmissionRequestHandler.handleActionEvent(SubmissionRequestHandler.java:98)
	at org.apache.sqoop.handler.SubmissionRequestHandler.handleEvent(SubmissionRequestHandler.java:68)
	at org.apache.sqoop.server.v1.SubmissionServlet.handlePostRequest(SubmissionServlet.java:44)
	at org.apache.sqoop.server.SqoopProtocolServlet.doPost(SqoopProtocolServlet.java:63)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
	at java.lang.Thread.run(Thread.java:662)
{code}


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira