[jira] [Issue Comment Deleted] (BIGTOP-1019) Remove mysql requirement constraint from sqoop tests

["jay vyas (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/BIGTOP-1019?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

jay vyas updated BIGTOP-1019:
-----------------------------

    Comment: was deleted

(was: So, I have created a simple smoke for sqoop , that is totally embedded: 

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

Any thoughts on integrating this as a "first pass", and iterating (maybe add a few hundred rows...).  

Or is it too simplistic ?  

)

> Remove mysql requirement constraint from sqoop tests
> ----------------------------------------------------
>
>                 Key: BIGTOP-1019
>                 URL: https://issues.apache.org/jira/browse/BIGTOP-1019
>             Project: Bigtop
>          Issue Type: Improvement
>          Components: Tests
>    Affects Versions: 0.6.0
>            Reporter: Konstantin Boudnik
>             Fix For: 0.8.0
>
>
> Existing Sqoop tests contradict self-sufficiency of the integration testing paradigm. The tests require an axillary mysql server configuration. While it might be acceptable for an established infrastructure it clearly has the disadvantage for ad-hoc testing, where one needs to make sure that a specially configured mysql is available.
> Replacing mysql with H2 for the testing would solve the problem elegantly.



--
This message was sent by Atlassian JIRA
(v6.1#6144)