Uploaded image for project: 'Sqoop'
  1. Sqoop
  2. SQOOP-2042

Sqoop2: "schema name" job config in JDBC FROM connector doesn't work as expected

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Not A Problem
    • Affects Version/s: None
    • Fix Version/s: 2.0.0
    • Component/s: None
    • Labels:
      None

      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.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              gwenshap Gwen Shapira
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: