[SQOOP-2042] Sqoop2: "schema name" job config in JDBC FROM connector doesn't work as expected

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Not A Problem
• Fix Version/s: 2.0.0
• Assignee: Unassigned
• Reporter: Gwen Shapira
• Created: 23/Jan/15 07:06
• Updated: 21/Oct/15 20:36
• Resolved: 21/Oct/15 20:36

Description

1. Created link with following connection string: jdbc:mysql://kafkaf-1:3306/hive1

2. Created job with this connector as "from" and schema = cm, table = hosts

3. Running job failed with error:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'hive1.HOSTS' doesn't exist
....
at org.apache.sqoop.connector.jdbc.GenericJdbcExecutor.getPrimaryKey(GenericJdbcExecutor.java:208)

4. Created new link, this time with connection string:
jdbc:mysql://kafkaf-1:3306

5. Created job with same configs but new connector

6. Got following error:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Incorrect database name ''
...
at org.apache.sqoop.connector.jdbc.GenericJdbcExecutor.getPrimaryKey(GenericJdbcExecutor.java:208)

It looks like the "schema name" config is completely useless.