[HIVE-23302] Create HiveJdbcDatabaseAccessor for JDBC storage handler

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Component/s: StorageHandler
• Labels: pull-request-available
• Target Version/s: 4.0.0
• Assignee: Jesus Camacho Rodriguez
• Reporter: Jesus Camacho Rodriguez
• Created: 26/Apr/20 19:10
• Updated: 17/Nov/22 08:49
• Resolved: 25/Aug/20 15:09

Description

The JdbcDatabaseAccessor associated with the storage handler makes some SQL calls to the RDBMS through the JDBC connection. There is a GenericJdbcDatabaseAccessor with a generic implementation that the storage handler uses if there is no specific implementation for a certain RDBMS.
Currently, Hive uses the GenericJdbcDatabaseAccessor. Afaik the only generic query that will not work is splitting the query based on offset and limit, since the syntax for that query is different than the one accepted by Hive. We should create a HiveJdbcDatabaseAccessor to override that query and possibly fix any other existing incompatibilities.

Issue Links

• relates to: HIVE-23291 Add Hive to DatabaseType in JDBC storage handler
• links to: GitHub Pull Request #1427