sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jarek Jarcec Cecho (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (SQOOP-1572) Sqoop2:Duplicate Column Name in Multiple Tables Import
Date Thu, 09 Oct 2014 13:43:34 GMT

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

Mime
View raw message