drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Nadeau (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-772) Null values are not filtered out in query result
Date Mon, 09 Jun 2014 07:17:04 GMT

    [ https://issues.apache.org/jira/browse/DRILL-772?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14021724#comment-14021724
] 

Jacques Nadeau commented on DRILL-772:
--------------------------------------

Adding to this, in the case of join, we currently incorrectly join on null values.  Need to
add alternative comparison implementations for join where nulls are not equal.

> 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 - Operators
>            Reporter: Krystal
>            Assignee: Jinfeng Ni
>
> 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