Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-20677

JDBC storage handler ordering problem - single split flag

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 3.2.0, 4.0.0-alpha-1
    • StorageHandler
    • None

    Description

      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.

      Attachments

        Issue Links

          Activity

            People

              jcamacho Jesús Camacho Rodríguez
              hagleitn Gunther Hagleitner
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: