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
