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

    • Sub-task
    • Status: Patch Available
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None
    • 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

              navis Navis Ryu
              ehans Eric N. Hanson
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated: