You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Krystal (JIRA)" <ji...@apache.org> on 2017/03/15 16:07:41 UTC
[jira] [Closed] (DRILL-772) Null values are not filtered out in
query result
[ https://issues.apache.org/jira/browse/DRILL-772?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Krystal closed DRILL-772.
-------------------------
Bug was verified.
> 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: Execution - Relational Operators
> Reporter: Krystal
> Fix For: 0.4.0
>
>
> 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.3.15#6346)