[IMPALA-5741] External JDBC Read Support

• Type: New Feature
• Status: In Progress
• Priority: Major
• Resolution: Unresolved
• Component/s: Distributed Exec
• Epic Color: ghx-label-1
• Assignee: Wenzhe Zhou
• Reporter: Istvan Vajnorak
• Created: 28/Jul/17 17:20
• Updated: 21/May/24 06:07

Description

In Hive there is a generic JDBC Storage handler that would be beneficial to be replicated into Impala. There are several workloads out that that could make good use of it.

The hive version of the handler is tracked under:
https://issues.apache.org/jira/browse/HIVE-1555

Please evaluate the possibility of including this into the roadmap at some point.

Issue Links

• Blocked: IMPALA-7131 Support external data sources in local catalog mode
• is duplicated by: IMPALA-8210 Support reading/writing tiny RDBMS tables
• is related to: IMPALA-12754 Update Impala document to cover external jdbc table
• is related to: HIVE-1555 JDBC Storage Handler

Sub-Tasks

• Support reading hive "information_schema" views in Impala: Open
• Update Impala document to cover external jdbc table: In Progress
• Fix unit-test code JdbcDataSourceTest.java: Open
• Support password protected keystore: Open
• Generate distributed plan for query accessing multiple JDBC tables: Open
• Performance improvement for impala-impala federation: Open
• Support for Hive JDBC Storage handler tables: Open
• Encrypt password in JDBC table properties when saving into HMS DB: Open
• Add TExprs of the columns to TBinaryPredicate for JDBC table: Open
• test_data_source_tables fails with Data source does not exist: Open