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

Limit Operator incorrectly reports sv2 mode

    XMLWordPrintableJSON

    Details

    • Type: New Feature
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.4.0
    • Component/s: Client - C++
    • Labels:
      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

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

                Dates

                • Created:
                  Updated:
                  Resolved: