[
https://issues.apache.org/jira/browse/SQOOP-1572?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14164838#comment-14164838
]
Abraham Elmahrek commented on SQOOP-1572:
-----------------------------------------
This was found using a free-form query that joined 2 tables together and
contained the same column name in each table. In the above exception, "ID" is
singled out. ID existed in both tables.
> 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 :
> 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)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
