hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jesus Camacho Rodriguez (Jira)" <j...@apache.org>
Subject [jira] [Comment Edited] (HIVE-23291) Add Hive to DatabaseType in JDBC storage handler
Date Sun, 26 Apr 2020 19:04:00 GMT

    [ https://issues.apache.org/jira/browse/HIVE-23291?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17092822#comment-17092822
] 

Jesus Camacho Rodriguez edited comment on HIVE-23291 at 4/26/20, 7:03 PM:
--------------------------------------------------------------------------

AFAIK the only generic query that will not work is splitting the query based on offset and
limit, since the syntax is different in the generic accessor.
 This is enabled only when quite tight conditions are met: user specifies number of partitions
per read in their table, Calcite does not disable the split \-for complex queries, this will
just not work\-, and user does not specify a partition column for a JDBC table.
 Fwiw that mode is bogus in any case because we cannot guarantee that records will come in
some order for multiple executions of same query, e.g., reading from other distributed RDBMSs.
 Nevertheless, since the mode is there, probably we should include a new Hive accessor like
you have mentioned.


was (Author: jcamachorodriguez):
AFAIK the only generic query that will not work is splitting the query based on offset and
limit, since the syntax is different in the generic accessor.
 This is enabled only when quite tight conditions are met: user specifies number of partitions
per read in their table, Calcite does not disable the split -for complex queries, this will
just not work-, and user does not specify a partition column for a JDBC table.
 Fwiw that mode is bogus in any case because we cannot guarantee that records will come in
some order for multiple executions of same query, e.g., reading from other distributed RDBMSs.
 Nevertheless, since the mode is there, probably we should include a new Hive accessor like
you have mentioned.

> Add Hive to DatabaseType in JDBC storage handler
> ------------------------------------------------
>
>                 Key: HIVE-23291
>                 URL: https://issues.apache.org/jira/browse/HIVE-23291
>             Project: Hive
>          Issue Type: Improvement
>          Components: StorageHandler
>            Reporter: Jesus Camacho Rodriguez
>            Assignee: Jesus Camacho Rodriguez
>            Priority: Major
>         Attachments: HIVE-23291.patch
>
>
> Inception.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Mime
View raw message