[
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)
