[SQOOP-1572] Sqoop2: Duplicate Column Name in Multiple Tables Import

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.99.4
• Fix Version/s: 1.99.5
• Component/s: sqoop2-hdfs-connector
• Assignee: Abraham Elmahrek
• Reporter: Shakun Grover
• Created: 09/Oct/14 06:19
• Updated: 24/Jan/15 01:30
• Resolved: 24/Jan/15 01:30

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 :

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)

Issue Links

• links to: RB