You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@drill.apache.org by "Krystal (JIRA)" <ji...@apache.org> on 2014/05/19 18:23:39 UTC

[jira] [Created] (DRILL-772) Null values are not filtered out in query result

Krystal created DRILL-772:
-----------------------------

             Summary: Null values are not filtered out in query result
                 Key: DRILL-772
                 URL: https://issues.apache.org/jira/browse/DRILL-772
             Project: Apache Drill
          Issue Type: Bug
          Components: Functions - Drill
            Reporter: Krystal


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.



--
This message was sent by Atlassian JIRA
(v6.2#6252)