Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
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.