[
https://issues.apache.org/jira/browse/IMPALA-12381?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Work on IMPALA-12381 started by Wenzhe Zhou.
--------------------------------------------
> Add jdbc related properties to JDBC data source object
> ------------------------------------------------------
>
> Key: IMPALA-12381
> URL: https://issues.apache.org/jira/browse/IMPALA-12381
> Project: IMPALA
> Issue Type: Sub-task
> Components: Backend, Frontend
> Reporter: Wenzhe Zhou
> Assignee: Wenzhe Zhou
> Priority: Major
>
> Currently jdbc related properties are specified as table properties when
> creating table as below:
> CREATE TABLE alltypes_jdbc_datasource (
> id INT, name STRING)
> PRODUCED BY DATA SOURCE JdbcDataSource (
> '{"database.type":"POSTGRES",
> "jdbc.url":"jdbc:postgresql://localhost:5432/functional",
> "jdbc.driver":"org.postgresql.Driver",
> "dbcp.username":"hiveuser",
> "dbcp.password":"password",
> "table":"alltypes"}');
> It's more convenient to move jdbc related properties to data source object as
> below so that user don't need to specify those properties for each table.
> CREATE DATA SOURCE JdbcDataSource
> LOCATION '/test-warehouse/data-sources/jdbc-data-source.jar'
> CLASS 'org.apache.impala.extdatasource.jdbc.JdbcDataSource'
> DATABSE-TYPE 'POSTGRES'
> JDBC-URL 'jdbc:postgresql://localhost:5432/functional'
> JDBC-DRIVER 'org.postgresql.Driver'
> DBCP-USERNAME 'hiveuser'
> DBCP-PASSWORD 'password'
> API_VERSION 'V1';
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
