Re: Failed to use sqoop-1.4.3 job tool on hadoop-2.1.0-beta

2013-11-19 Thread sam liu
I found a solution to resolve this issue: replace the content of ˜/.sqoop/metastore.db.script with following codes. However, I have a questions: what code generated ˜/.sqoop/metastore.db.script? Codes for replacement: SET DATABASE UNIQUE NAME HSQLDB427399082E SET DATABASE GC 0 SET DATABASE DEFAULT

Re: Failed to use sqoop-1.4.3 job tool on hadoop-2.1.0-beta

2013-11-19 Thread sam liu
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 > Updated the exception info: > > > Now I failed to run sqoop-1.4.3 job tool($SQOOP_HOME/bin

Re: Failed to use sqoop-1.4.3 job tool on hadoop-2.1.0-beta

2013-11-18 Thread sam liu
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 ERR

Failed to use sqoop-1.4.3 job tool on hadoop-2.1.0-beta

2013-11-18 Thread sam liu
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