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)