Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-707

Limit Operator incorrectly reports sv2 mode

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 0.4.0
    • Client - C++
    • None

    Description

      Drill C++ client needs to support selection vector.
      The drillbit should never be sending sv2 to client.
      Queries with limit operator will return record batch with selection vector as true.

      For example, given the following hive table,

      +------------+------------+
      | keycolumn  |  column1   |
      +------------+------------+
      | Zero       | 0          |
      | One        | 1          |
      | MinusOne   | -1         |
      | Two        | 2          |
      | MaxTInt    | 127        |
      | MinTInt    | -128       |
      | MaxUTInt   | 255        |
      | MaxTIntP1  | 128        |
      | MinTIntM1  | -129       |
      | MaxUTIntP1 | 256        |
      | MaxSInt    | 32767      |
      | MinSInt    | -32768     |
      | MaxUSInt   | 65535      |
      | MinSIntM1  | -32769     |
      | MaxSIntP1  | 32768      |
      | MaxUSIntP1 | 65536      |
      | MaxInt     | 2147483647 |
      | MinInt     | -2147483648 |
      | MaxUInt    | 4294967295 |
      | MaxIntP1   | 2147483648 |
      | MinIntM1   | -2147483649 |
      | MaxUIntP1  | 4294967296 |
      | MaxBInt    | 9223372036854775807 |
      | MinBInt    | -9223372036854775808 |
      +------------+------------+
      

      We issue the following two queries:
      Query 1:

      select column1 from hivestg.`bigint_table` where keycolumn='Zero'
      

      Query 2:

      select column1 from hivestg.`bigint_table` limit 1
      

      Query 2 will return record batch with is_section_vector_2 as true

      Attachments

        1. Q1vsQ2.png
          74 kB
          Xiaomeng Huang

        Issue Links

          Activity

            People

              jni Jinfeng Ni
              xiaom Xiaomeng Huang
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: