Wenzhe Zhou created IMPALA-12381:
------------------------------------
Summary: 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
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)
