[IMPALA-12381] Add jdbc related properties to JDBC data source object

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Won't Fix
• Fix Version/s: Impala 4.4.0
• Component/s: Backend, Frontend
• Epic Color: ghx-label-9
• Assignee: Wenzhe Zhou
• Reporter: Wenzhe Zhou
• Created: 17/Aug/23 20:34
• Updated: 08/Feb/24 02:57
• Resolved: 08/Feb/24 02:09

Description

Currently jdbc related properties are specified as initString 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 data-source properties as following sample 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'
DSPROPERTIES (
'DATABSE.TYPE'='POSTGRES',
'JDBC.URL'='jdbc:postgresql://localhost:5432/functional',
'JDBC.DRIVER'='org.postgresql.Driver',
'DBCP.USERNAME'='hiveuser',
'DBCP.PASSWORD'='password');