[
https://issues.apache.org/jira/browse/HIVE-20677?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jesus Camacho Rodriguez updated HIVE-20677:
-------------------------------------------
Resolution: Fixed
Fix Version/s: 4.0.0
Status: Resolved (was: Patch Available)
Fixed as part of HIVE-20652.
> 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
> Fix For: 4.0.0
>
>
> 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)
