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

Could not change the sqoop metastore username in the sqoop-site.xml ?

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.4.6
    • Fix Version/s: None
    • Component/s: metastore
    • Labels:
      None
    • Environment:

      sqoop-1.4.6
      hadoop-2.6.0

      Description

      sqoop job --list
      Warning: /usr/lib/sqoop/../accumulo does not exist! Accumulo imports will fail.
      Please set $ACCUMULO_HOME to the root of your Accumulo installation.
      16/02/26 12:00:47 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6
      16/02/26 12:00:47 ERROR tool.JobTool: I/O error performing job operation: java.io.IOException: Exception creating SQL connection
      at org.apache.sqoop.metastore.hsqldb.HsqldbJobStorage.init(HsqldbJobStorage.java:216)
      at org.apache.sqoop.metastore.hsqldb.AutoHsqldbStorage.open(AutoHsqldbStorage.java:112)
      at org.apache.sqoop.tool.JobTool.run(JobTool.java:274)
      at org.apache.sqoop.Sqoop.run(Sqoop.java:143)
      at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
      at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179)
      at org.apache.sqoop.Sqoop.runTool(Sqoop.java:218)
      at org.apache.sqoop.Sqoop.runTool(Sqoop.java:227)
      at org.apache.sqoop.Sqoop.main(Sqoop.java:236)
      Caused by: java.sql.SQLException: User not found: SQOOP
      at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
      at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
      at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
      at org.hsqldb.jdbcDriver.connect(Unknown Source)
      at java.sql.DriverManager.getConnection(DriverManager.java:571)
      at java.sql.DriverManager.getConnection(DriverManager.java:215)
      at org.apache.sqoop.metastore.hsqldb.HsqldbJobStorage.init(HsqldbJobStorage.java:176)
      ... 8 more

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              alexBai alexBai
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: