I am confusing these exceptions... For using 'sqoop job --list' command, sqoop will connect to hsqldb, and need hsqldb has a database for storing sqoop job metadata in advance, right?
2013/11/19 sam liu <[email protected]> > Updated the exception info: > > > Now I failed to run sqoop-1.4.3 job tool($SQOOP_HOME/bin/sqoop job --list) > agains hadoop-2.1.0-beta: > 1) If I use hsqldb-2.0.0.jar in my env, the exception will be:13/11/18 > 21:52:47 WARN hsqldb.HsqldbJobStorage: Could not interpret as a number: null > 13/11/18 21:52:47 ERROR hsqldb.HsqldbJobStorage: Can not interpret > metadata schema > 13/11/18 21:52:47 ERROR hsqldb.HsqldbJobStorage: The metadata schema > version is null > 13/11/18 21:52:47 ERROR hsqldb.HsqldbJobStorage: The highest version > supported is 0 > 13/11/18 21:52:47 ERROR hsqldb.HsqldbJobStorage: To use this version of > Sqoop, you must downgrade your metadata schema. > 13/11/18 21:52:47 ERROR tool.JobTool: I/O error performing job operation: > java.io.IOException: Invalid metadata version. > at > org.apache.sqoop.metastore.hsqldb.HsqldbJobStorage.init(HsqldbJobStorage.java:202) > > 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:145) > at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) > at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181) > at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220) > at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229) > at org.apache.sqoop.Sqoop.main(Sqoop.java:238) > > > 2) If I use hsqldb-1.8.0.10.jar in my env, the exception will be: > Exception in thread "main" java.lang.NoSuchMethodError: > org/hsqldb/DatabaseURL. > parseURL(Ljava/lang/String;ZZ)Lorg/hsqldb/persist/HsqlProperties; > at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source) > at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source) > at java.sql.DriverManager.getConnection(DriverManager.java:419) > at java.sql.DriverManager.getConnection(DriverManager.java:467) > at > org.apache.sqoop.metastore.hsqldb.HsqldbJobStorage.init(HsqldbJobStorage.java:176) > 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:145) > at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) > at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181) > at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220) > at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229) > at org.apache.sqoop.Sqoop.main(Sqoop.java:238) > > > > 2013/11/19 sam liu <[email protected]> > >> Hi Experts, >> >> My cluster is hadoop-2.1.0-beta and it requires hsqldb-2.0.0.jar. At the >> same time, my sqoop is 1.4.3, and it requires hsqldb-1.8.0.10.jar. >> >> Now I failed to run sqoop-1.4.3 job tool($SQOOP_HOME/bin/sqoop job >> --list) agains hadoop-2.1.0-beta: >> 1) If I use hsqldb-2.0.0.jar in my env, the exception will be: >> Exception in thread "main" java.lang.NoSuchMethodError: >> org/hsqldb/DatabaseURL.parseURL(Ljava/lang/String;ZZ)Lorg/hsqldb/persist/HsqlProperties; >> at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source) >> at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source) >> at java.sql.DriverManager.getConnection(DriverManager.java:419) >> at java.sql.DriverManager.getConnection(DriverManager.java:467) >> at >> org.apache.sqoop.metastore.hsqldb.HsqldbJobStorage.init(HsqldbJobStorage.java:176) >> 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:145) >> at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) >> at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181) >> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220) >> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229) >> at org.apache.sqoop.Sqoop.main(Sqoop.java:238) >> >> 2) If I use hsqldb-1.8.0.10.jar in my env, the exception will be: >> Exception in thread "main" java.lang.NoSuchMethodError: >> org/hsqldb/DatabaseURL.parseURL(Ljava/lang/String;ZZ)Lorg/hsqldb/persist/HsqlProperties; >> at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source) >> at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source) >> at java.sql.DriverManager.getConnection(DriverManager.java:419) >> at java.sql.DriverManager.getConnection(DriverManager.java:467) >> at >> org.apache.sqoop.metastore.hsqldb.HsqldbJobStorage.init(HsqldbJobStorage.java:176) >> 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:145) >> at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) >> at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181) >> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220) >> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229) >> at org.apache.sqoop.Sqoop.main(Sqoop.java:238) >> >> Is it a defect of Sqoop? >> >> Thanks! >> >> -- >> >> Sam Liu >> > > > > -- > > Sam Liu > -- Sam Liu
