You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@bigtop.apache.org by "jay vyas (JIRA)" <ji...@apache.org> on 2013/10/31 18:55:18 UTC
[jira] [Commented] (BIGTOP-1019) Remove mysql requirement
constraint from sqoop tests
[ https://issues.apache.org/jira/browse/BIGTOP-1019?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13810488#comment-13810488 ]
jay vyas commented on BIGTOP-1019:
----------------------------------
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)