Apache Drill
  1. Apache Drill
  2. DRILL-772

Null values are not filtered out in query result

    Details

      Description

      git.commit.id.abbrev=70fab8c

      0: jdbc:drill:schema=dfs> select voter_id, name, age from voter where age not between 20 and 80;
      --------------------------------

      voter_id name age

      --------------------------------

      3 [B@183c94e6 18
      17 [B@31539478 null
      22 [B@66386b94 19
      57 [B@21ef5fa 19
      59 [B@3ea6f12c 18
      70 [B@42239fd6 18
      85 [B@30d2bc86 19
      92 [B@5b571a74 null
      109 [B@3389e485 18
      111 [B@21f9f232 18

      The output above returned age with "null" values. In oracle and postgres, the rows with "null" value for age are filtered out.

        Activity

          People

          • Assignee:
            Unassigned
            Reporter:
            Krystal
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development