[jira] [Assigned] (HIVE-23302) Create HiveJdbcDatabaseAccessor for JDBC storage handler

["Jesus Camacho Rodriguez (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-23302?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jesus Camacho Rodriguez reassigned HIVE-23302:
----------------------------------------------

    Assignee: Jesus Camacho Rodriguez

> 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
>
> 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)