[ https://issues.apache.org/jira/browse/HIVE-23302?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jesus Camacho Rodriguez updated HIVE-23302: ------------------------------------------- Fix Version/s: 4.0.0 Resolution: Fixed Status: Resolved (was: Patch Available) Pushed to master. > Create HiveJdbcDatabaseAccessor for JDBC storage handler > -------------------------------------------------------- > > Key: HIVE-23302 > URL: https://issues.apache.org/jira/browse/HIVE-23302 > Project: Hive > Issue Type: Bug > Components: StorageHandler > Reporter: Jesus Camacho Rodriguez > Assignee: Jesus Camacho Rodriguez > Priority: Major > Labels: pull-request-available > Fix For: 4.0.0 > > Time Spent: 20m > Remaining Estimate: 0h > > 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. -- This message was sent by Atlassian Jira (v8.3.4#803005)