...
- Install MySQL version 5.1.x with necessary client tools. You can install the server in a different host than your development host if necessary. However, you must have the client tools available on your development host including the JDBC driver, and batch utilities such as
mysqldump
andmysqlimport
. - Place the JDBC driver in the third-party lib directory that you created earlier.
- The location of MySQL server is specified in the
build.properties
file by the value for the propertysqoop.test.mysql.connectstring.host_url
. This property defaults tojdbc:mysql://localhost/
which assumes local installation and default port setup. If however your MySQL server is installed on a different host , enter its location in thebuild.properties
file or on a different port you should specify it explicitly as follows:Code Block sqoop.test.mysql.connectstring.host_url=jdbc:mysql://mysqlhost<mysqlhost>:<port>/
- In order to run the MySQL third-party tests, you would need to configure the database as follows:
Code Block $ mysql -u root -p mysql> CREATE DATABASE sqooppasstest; mysql> CREATE DATABASE sqooptestdb; mysql> use mysql; mysql> GRANT ALL PRIVILEGES on sqooppasstest.* TO 'sqooptest'@'localhost' IDENTIFIED BY '12345'; mysql> GRANT ALL PRIVILEGES ON sqooptestdb.* TO 'yourusername'@'localhost'; mysql> flush privileges;
- Note:
- If the installation of MySQL server is on a different host, you must replace the
localhost
with the appropriate client host value. - You should replace
yourusername
with your actual user name before issuing the command.
- If the installation of MySQL server is on a different host, you must replace the
Setting up PostgreSQL
- Install PostgreSQL 8.3.9 or later along with client tools. You can install the server in a different host than your development host if necessary. However, you must have the client tools available on your development host including the JDBC driver and command line utility
psql
. - Place the JDBC driver in the third-party lib directory that you created earlier.
- If your PostgreSQL server is installed on a different host, enter its location in the
build.properties
file as follows:Code Block sqoop.test.postgresql.connectstring.host_url=jdbc:postgresql://pgsqlhost/
- In order to run PostgreSQL third-party tests, you would need to configure the database as follows:
Code Block