[ 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: issues-all-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org