You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Jesus Camacho Rodriguez (JIRA)" <ji...@apache.org> on 2018/10/03 16:08:00 UTC
[jira] [Updated] (HIVE-20677) JDBC storage handler ordering problem
- single split flag
[ https://issues.apache.org/jira/browse/HIVE-20677?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jesus Camacho Rodriguez updated HIVE-20677:
-------------------------------------------
Status: Patch Available (was: Open)
> JDBC storage handler ordering problem - single split flag
> ---------------------------------------------------------
>
> Key: HIVE-20677
> URL: https://issues.apache.org/jira/browse/HIVE-20677
> Project: Hive
> Issue Type: Bug
> Components: StorageHandler
> Reporter: Gunther Hagleitner
> Assignee: Jesus Camacho Rodriguez
> Priority: Major
>
> When Calcite is pushing queries into the JDBC handler splitting the query via offset/limit can cause issues (RDBMs is not guaranteed to return the data in the same order every time.)
> For these cases we want to:
> a) Add a "do not split" flag to the jdbc handler. In that mode jdbc handler will skip the count and offset/limit processing but just run the query in a single node. Flag default will be false.
> b) Have calcite automatically set this flag.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)