[email protected] has uploaded this change for review. (
http://gerrit.cloudera.org:8080/20710
Change subject: IMPALA-12471: Scripts to run unit tests of external jdbc tables
for mysql
......................................................................
IMPALA-12471: Scripts to run unit tests of
external jdbc tables for mysql
This patch adds mysql tests for the "external data source"
mechanism in Impala to implement data source for querying JDBC.
In order to query the mysql RDBMS tables, the following steps
should be followed (note that existing data source table will be
rebuilt):
1. Make sure the Impala cluster has been started.
2. Download and Copy the mysql jar files of JDBC drivers and the
data source library into HDFS.
${IMPALA_HOME}/testdata/bin/copy-ext-data-sources.sh
3. Create an `alltypes` table in the Postgres database.
${IMPALA_HOME}/testdata/bin/load-ext-data-sources.sh
4. Create data source tables (alltypes_jdbc_datasource and
alltypes_jdbc_datasource_2).
${IMPALA_HOME}/bin/impala-shell.sh -f\
${IMPALA_HOME}/testdata/bin/create-ext-data-source-table.sql
5. Run the query from impala-shell to query mysql database::
impala-shell -Bq 'use functional; select count(*) from \
alltypes_jdbc_mysql_datasource' 2>&1 | tail -2 | head -1
It should run successfully and fetch the row count from mysql
database.
Change-Id: I446ec3d4ebaf53c8edac0b2d181514bde587dfae
---
M testdata/bin/copy-ext-data-sources.sh
M testdata/bin/create-ext-data-source-table.sql
M testdata/bin/load-ext-data-sources.sh
3 files changed, 144 insertions(+), 2 deletions(-)
git pull ssh://gerrit.cloudera.org:29418/Impala-ASF refs/changes/10/20710/1
--
To view, visit http://gerrit.cloudera.org:8080/20710
To unsubscribe, visit http://gerrit.cloudera.org:8080/settings
Gerrit-Project: Impala-ASF
Gerrit-Branch: master
Gerrit-MessageType: newchange
Gerrit-Change-Id: I446ec3d4ebaf53c8edac0b2d181514bde587dfae
Gerrit-Change-Number: 20710
Gerrit-PatchSet: 1
Gerrit-Owner: Anonymous Coward <[email protected]>
