[
https://issues.apache.org/jira/browse/IMPALA-12381?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Wenzhe Zhou updated IMPALA-12381:
---------------------------------
Description:
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'
API_VERSION 'V1'
DS
DATABSE-TYPE 'POSTGRES'
JDBC-URL 'jdbc:postgresql://localhost:5432/functional'
JDBC-DRIVER 'org.postgresql.Driver'
DBCP-USERNAME 'hiveuser'
DBCP-PASSWORD 'password'
was:
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';
> 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'
> API_VERSION 'V1'
> DS
> DATABSE-TYPE 'POSTGRES'
> JDBC-URL 'jdbc:postgresql://localhost:5432/functional'
> JDBC-DRIVER 'org.postgresql.Driver'
> DBCP-USERNAME 'hiveuser'
> DBCP-PASSWORD 'password'
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
