[
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, 6:45 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 are 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 are 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)
