[HIVE-22392] Hive JDBC Storage Handler: Support For Writing Data to JDBC Data Source

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Component/s: StorageHandler
• Labels: pull-request-available todoc4.0
• Target Version/s: 4.0.0
• Assignee: Syed Shameerur Rahman
• Reporter: Syed Shameerur Rahman
• Created: 23/Oct/19 04:15
• Updated: 27/Feb/24 22:23
• Resolved: 12/Nov/19 08:16

Description

JDBC Storage Handler supports reading from JDBC data source in Hive. Currently writing to a JDBC data source is not supported. Hence adding support for simple insert query so that the data can be written back to JDBC data source.

Issue Links

• fixes: HIVE-19502 Unable to insert values into table stored by JdbcStorageHandler
• is blocked by: HIVE-22431 Hive JDBC Storage Handler: java.lang.ClassCastException on accessing TINYINT, SMALLINT Data Type From JDBC Data Source
• is blocked by: HIVE-22433 Hive JDBC Storage Handler: Incorrect results fetched from BOOLEAN and TIMESTAMP DataType From JDBC Data Source
• links to: GitHub Pull Request #829