[ https://issues.apache.org/jira/browse/HIVE-25594?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ASF GitHub Bot updated HIVE-25594: ---------------------------------- Labels: pull-request-available (was: ) > Setup JDBC databases in tests via QT options > -------------------------------------------- > > Key: HIVE-25594 > URL: https://issues.apache.org/jira/browse/HIVE-25594 > Project: Hive > Issue Type: Improvement > Components: Testing Infrastructure > Reporter: Stamatis Zampetakis > Assignee: Stamatis Zampetakis > Priority: Major > Labels: pull-request-available > Time Spent: 10m > Remaining Estimate: 0h > > The goal of this jira is to add a new QT option for setting up JDBC DBMS and > using it in qtests which need a JDBC endpoint up and running. It can be used > in tests with external JDBC tables, connectors, etc. > A sample file using the proposed option ({{qt:database}}) is shown below. > {code:sql} > --!qt:database:postgres:init_sript_1234.sql:cleanup_script_1234.sql > CREATE EXTERNAL TABLE country (name varchar(80)) > STORED BY 'org.apache.hive.storage.jdbc.JdbcStorageHandler' > TBLPROPERTIES ( > "hive.sql.database.type" = "POSTGRES", > "hive.sql.jdbc.driver" = "org.postgresql.Driver", > "hive.sql.jdbc.url" = "jdbc:postgresql://localhost:5432/qtestDB", > "hive.sql.dbcp.username" = "qtestuser", > "hive.sql.dbcp.password" = "qtestpassword", > "hive.sql.table" = "country"); > EXPLAIN CBO SELECT COUNT(*) from country; > SELECT COUNT(*) from country; > {code} > This builds upon HIVE-25423 but proposes to use JDBC datasources without the > need for a using a specific CLI driver. Furthermore, the proposed QT option > syntax allows using customised init/cleanup scripts for the JDBC datasource > per test. -- This message was sent by Atlassian Jira (v8.3.4#803005)