You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "ASF subversion and git services (Jira)" <ji...@apache.org> on 2023/10/13 00:55:00 UTC
[jira] [Commented] (IMPALA-12470) Support different schemes for jdbc driver url when creating external jdbc table
[ https://issues.apache.org/jira/browse/IMPALA-12470?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17774730#comment-17774730 ]
ASF subversion and git services commented on IMPALA-12470:
----------------------------------------------------------
Commit 5b155c13929ea8636fa2dfbdfc07a0acb48b0f3e in impala's branch refs/heads/master from wzhou-code
[ https://gitbox.apache.org/repos/asf?p=impala.git;h=5b155c139 ]
IMPALA-12470: Skip JDBC data source tests for non-HDFS environment
IMPALA-5741 added initial support for external JDBC data source. But
the JDBC driver URL only works for HDFS now, other schemes like ozone
are still under developemnt.
This patch turns off tests of JDBC data source for non-HDFS
environments temporally.
Testing:
- Manually ran tests/query_test/test_ext_data_sources.py
Change-Id: I4b162767afc567065ae61961ffb376c17c32ec29
Reviewed-on: http://gerrit.cloudera.org:8080/20563
Reviewed-by: Impala Public Jenkins <im...@cloudera.com>
Tested-by: Impala Public Jenkins <im...@cloudera.com>
> 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
> Priority: Major
>
> 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)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org