[SQOOP-3296] 'Duplicate Colum identifier' for DB2.

• Type: Task
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Component/s: sqoop2-api

Environment

Cloudera with Sqoop 

• Assignee: Unassigned
• Reporter: Ganesh Rajan Thiyagarajan
• Created: 19/Mar/18 06:39
• Updated: 19/Mar/18 06:39

Description

I am facing issues with 'Duplicate Colum identifier' for DB2. Other database has no issues as their column names are unique, but it is bit different for the DB.

Is there any way for me to give manual column name instead of picking up from automatically?

 

I have tried to give column name in the query (ie selelct PAGRP as groupid from TB) but the query doesn't seem to work. The query works in the actual database.

 

 

It may work for mysql but not for DB2.