Wenzhe Zhou created IMPALA-12470:
------------------------------------

             Summary: Support different schemes for jdbc driver url when 
creating external jdbc table
                 Key: IMPALA-12470
                 URL: https://issues.apache.org/jira/browse/IMPALA-12470
             Project: IMPALA
          Issue Type: Sub-task
          Components: Frontend
            Reporter: Wenzhe Zhou


jdbc driver url is specified as table property 'driver.url' when creating a 
external jdbc table, like the sample below:
{code:java}
CREATE TABLE test_postgres (
 id INT,
 string_col STRING)
PRODUCED BY DATA SOURCE JdbcDataSource(
'{"database.type":"POSTGRES",
"jdbc.url":"jdbc:postgresql://localhost:5432/functional",
"jdbc.driver":"org.postgresql.Driver",
"driver.url":"hdfs://localhost:20500/test-warehouse/data-sources/jdbc-driver/postgresql-jdbc.jar",
"dbcp.username":"hiveuser",
"dbcp.password":"password",
"table":"alltypes"}');
{code}
In the initial patch, we only support to download the driver jar files from 
hdfs.  We need to support different storage type, like 'file://', 's3a://', 
etc.   



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to