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)

Reply via email to