simplesmoke for sqoop

gistfile1.txt

hsql=`find $SQOOP_HOME/lib -name hsql*jar`
echo "hsql : $hsql"

rm -rf /tmp/sqsmoke

# Create db permissions
echo "
# A personal, local, persistent database.
urlid smoketest
url jdbc:hsqldb:file:/tmp/sqsmoke;shutdown=true
username SA
password
#transiso TRANSACTION_READ_COMMITTED" > $HOME/sqltool.rc

# SQL Statements to execute. 
echo "CREATE TABLE t (i INT PRIMARY KEY, v VARCHAR(25), d DATE);
INSERT INTO t(i, v, d) VALUES (1, 'one two three', null);
INSERT INTO t(i, v, d) VALUES (2, null, '2007-06-24');
INSERT INTO t(i, v, d) VALUES (3, 'one,two,,three', '2007-06-24');
INSERT INTO t(i, v, d) VALUES (4, '"one"two""three', '2007-06-24');
INSERT INTO t(i, v, d) VALUES (5, '"one,two"three,', '2007-06-24');
INSERT INTO t(i, v, d) VALUES (6, '', '2007-06-24');
commit;" > testsqoop.sql

# Create a simple database into hsql: 
#java -jar /usr/lib/sqoop/lib/hsqldb-1.8.0.10.jar smoketest testsqoop.sql
java -jar $hsql smoketest testsqoop.sql

# 
ls -altrh /tmp/sqsmoke

/usr/lib/sqoop/bin/sqoop import-all-tables -libjars $hsql --connect jdbc:hsqldb:file:/tmp/sqsmoke