Gwen Shapira created SQOOP-2042:
-----------------------------------
Summary: Sqoop2: "schema name" job config in JDBC FROM connector
doesn't work as expected
Key: SQOOP-2042
URL: https://issues.apache.org/jira/browse/SQOOP-2042
Project: Sqoop
Issue Type: Bug
Reporter: Gwen Shapira
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.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
