You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by "Jarek Jarcec Cecho (JIRA)" <ji...@apache.org> on 2014/10/09 15:43:34 UTC

[jira] [Updated] (SQOOP-1572) Sqoop2:Duplicate Column Name in Multiple Tables Import

     [ https://issues.apache.org/jira/browse/SQOOP-1572?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jarek Jarcec Cecho updated SQOOP-1572:
--------------------------------------
    Description: 
While importing multiple tables' data to HDFS,if same column name is there in more than one table. It gives me exception while starting the job:
Exception :
{code}
job.org.apache.sqoop.common.SqoopException: SCHEMA_0002:Duplicate column name - Column: FixedPoint{name=id,nullable=null,byteSize=null,unsigned=null}
	at org.apache.sqoop.schema.Schema.addColumn(Schema.java:88)
	at org.apache.sqoop.connector.jdbc.GenericJdbcImportInitializer.getSchema(GenericJdbcImportInitializer.java:99)
	at org.apache.sqoop.connector.jdbc.GenericJdbcImportInitializer.getSchema(GenericJdbcImportInitializer.java:40)
	at org.apache.sqoop.framework.JobManager.submit(JobManager.java:388)
	at org.apache.sqoop.handler.SubmissionRequestHandler.submissionSubmit(SubmissionRequestHandler.java:152)
	at org.apache.sqoop.handler.SubmissionRequestHandler.handleActionEvent(SubmissionRequestHandler.java:122)
	at org.apache.sqoop.handler.SubmissionRequestHandler.handleEvent(SubmissionRequestHandler.java:75)
	at org.apache.sqoop.server.v1.SubmissionServlet.handlePostRequest(SubmissionServlet.java:44)
	at org.apache.sqoop.server.SqoopProtocolServlet.doPost(SqoopProtocolServlet.java:63)
{code}

  was:
While importing multiple tables' data to HDFS,if same column name is there in more than one table. It gives me exception while starting the job:
Exception :
job.org.apache.sqoop.common.SqoopException: SCHEMA_0002:Duplicate column name - Column: FixedPoint{name=id,nullable=null,byteSize=null,unsigned=null}
	at org.apache.sqoop.schema.Schema.addColumn(Schema.java:88)
	at org.apache.sqoop.connector.jdbc.GenericJdbcImportInitializer.getSchema(GenericJdbcImportInitializer.java:99)
	at org.apache.sqoop.connector.jdbc.GenericJdbcImportInitializer.getSchema(GenericJdbcImportInitializer.java:40)
	at org.apache.sqoop.framework.JobManager.submit(JobManager.java:388)
	at org.apache.sqoop.handler.SubmissionRequestHandler.submissionSubmit(SubmissionRequestHandler.java:152)
	at org.apache.sqoop.handler.SubmissionRequestHandler.handleActionEvent(SubmissionRequestHandler.java:122)
	at org.apache.sqoop.handler.SubmissionRequestHandler.handleEvent(SubmissionRequestHandler.java:75)
	at org.apache.sqoop.server.v1.SubmissionServlet.handlePostRequest(SubmissionServlet.java:44)
	at org.apache.sqoop.server.SqoopProtocolServlet.doPost(SqoopProtocolServlet.java:63)


> Sqoop2:Duplicate Column Name in Multiple Tables Import
> ------------------------------------------------------
>
>                 Key: SQOOP-1572
>                 URL: https://issues.apache.org/jira/browse/SQOOP-1572
>             Project: Sqoop
>          Issue Type: Bug
>          Components: sqoop2-hdfs-connector
>            Reporter: Shakun Grover
>
> While importing multiple tables' data to HDFS,if same column name is there in more than one table. It gives me exception while starting the job:
> Exception :
> {code}
> job.org.apache.sqoop.common.SqoopException: SCHEMA_0002:Duplicate column name - Column: FixedPoint{name=id,nullable=null,byteSize=null,unsigned=null}
> 	at org.apache.sqoop.schema.Schema.addColumn(Schema.java:88)
> 	at org.apache.sqoop.connector.jdbc.GenericJdbcImportInitializer.getSchema(GenericJdbcImportInitializer.java:99)
> 	at org.apache.sqoop.connector.jdbc.GenericJdbcImportInitializer.getSchema(GenericJdbcImportInitializer.java:40)
> 	at org.apache.sqoop.framework.JobManager.submit(JobManager.java:388)
> 	at org.apache.sqoop.handler.SubmissionRequestHandler.submissionSubmit(SubmissionRequestHandler.java:152)
> 	at org.apache.sqoop.handler.SubmissionRequestHandler.handleActionEvent(SubmissionRequestHandler.java:122)
> 	at org.apache.sqoop.handler.SubmissionRequestHandler.handleEvent(SubmissionRequestHandler.java:75)
> 	at org.apache.sqoop.server.v1.SubmissionServlet.handlePostRequest(SubmissionServlet.java:44)
> 	at org.apache.sqoop.server.SqoopProtocolServlet.doPost(SqoopProtocolServlet.java:63)
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)