[SQOOP-476] If table name is a qualified name, Sqoop import fails in DB2

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.4.2
• Assignee: Cheolsoo Park
• Reporter: Cheolsoo Park
• Created: 05/Apr/12 22:29
• Updated: 17/Jul/12 22:29
• Resolved: 01/Jun/12 17:35

Description

In DB2, it is OK to have a dot "." in table name, but it is not in alias. For example, the following query fails:

SELECT * FROM foo.bar AS foo.bar

SQL0104N  An unexpected token "." was found following "from foo.bar as foo".  
Expected tokens may include:  ",".  SQLSTATE=42601

During the import job, Sqoop uses the following select query:

SELECT <column names> FROM <table name> AS <table name>

As can be seen, it can be a problem for DB2 if table name has a dot "." in it.