sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sam liu <liuqiyun2...@gmail.com>
Subject Re: Failed to use sqoop-1.4.3 job tool on hadoop-2.1.0-beta
Date Tue, 19 Nov 2013 06:08:04 GMT
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 <liuqiyun2011@gmail.com>

> 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

Mime
View raw message