You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Jesus Camacho Rodriguez (JIRA)" <ji...@apache.org> on 2018/10/03 02:00:00 UTC

[jira] [Created] (HIVE-20677) JDBC storage handler ordering problem - single split flag

Jesus Camacho Rodriguez created HIVE-20677:
----------------------------------------------

             Summary: 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


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)