drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Krystal (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-772) Null values are not filtered out in query result
Date Mon, 19 May 2014 16:23:39 GMT
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)

Mime
View raw message