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

["Veena Basavaraj (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/SQOOP-2042?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Veena Basavaraj updated SQOOP-2042:
-----------------------------------
    Fix Version/s: 2.0.0

> 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
>             Fix For: 2.0.0
>
>
> 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)