Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-4160 Vectorized Query Execution in Hive
  3. HIVE-5744

Implement support for BETWEEN in SELECT list

    XMLWordPrintableJSON

    Details

    • Type: Sub-task
    • Status: Patch Available
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      Queries like

      SELECT col1 BETWEEN 0 and 10 from T;

      fail in vectorized mode. Support needs to be implemented for a BETWEEN expression in the SELECT list, comparable to how it was added for comparison operators (<, >, ...). These were done by adding new, templates that return a value for a comparison instead of applying a filter. See ColumnCompareScalar.txt under ql/src/gen for an example.

        Attachments

        1. HIVE-5744.1.patch.txt
          82 kB
          Navis Ryu
        2. HIVE-5744.2.patch.txt
          82 kB
          Navis Ryu

          Issue Links

          blocks

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-7849 Support more generic predicate pushdown for hbase handler

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Patch Available
          links to

          Web Link review board

            Activity

              People

              • Assignee:
                navis Navis Ryu
                Reporter:
                ehans Eric N. Hanson
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated: