[
https://issues.apache.org/jira/browse/DRILL-5201?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15829565#comment-15829565
]
mehran edited comment on DRILL-5201 at 1/19/17 9:43 AM:
--------------------------------------------------------
I added sample data and query is updated to:
SELECT event_source_id FROM dfs.root.`/repositories/01/2017/01/16/20`
Tlb0 where event_source_id = 2000163 LIMIT 100 OFFSET 0
This query returns null values that should not have.
Besides another evidence is that (I do not know if this issue is related to
null value or not) two queries has inconsistent results: the problem is as
follows:
This query has a count of 2 for null values :
SELECT event_source_id, count(*) FROM
dfs.root.`/repositories/01/2017/01/16/20` Tlb0 WHERE event_source_id IS NULL
GROUP BY event_source_id LIMIT 100 OFFSET 0
Another query that I remove where condition has 30 results for null values:
SELECT event_source_id, count(*) FROM
dfs.root.`/repositories/01/2017/01/16/20` Tlb0 GROUP BY event_source_id LIMIT
100 OFFSET 0
These two queries has inconsistent count for null values;
Thank you for your attention
was (Author: mehran):
I added sample data and query is updated to:
SELECT event_source_id FROM dfs.root.`/repositories/01/2017/01/16/20`
Tlb0 where event_source_id = 2000163 LIMIT 100 OFFSET 0
This query returns null values.
Besides query result is null. I do not know if this issue is related to null
value or not but the problem is as follows:
This query has a count of 2 for null values :
SELECT event_source_id, count(*) FROM
dfs.root.`/repositories/01/2017/01/16/20` Tlb0 WHERE event_source_id IS NULL
GROUP BY event_source_id LIMIT 100 OFFSET 0
Another query that I remove where condition has 30 results for null values:
SELECT event_source_id, count(*) FROM
dfs.root.`/repositories/01/2017/01/16/20` Tlb0 GROUP BY event_source_id LIMIT
100 OFFSET 0
These two queries has different count for null values;
Thank you for your attention
> Query bug: null values in result of a conditioned query
> ---------------------------------------------------------
>
> Key: DRILL-5201
> URL: https://issues.apache.org/jira/browse/DRILL-5201
> Project: Apache Drill
> Issue Type: Bug
> Components: Client - HTTP
> Affects Versions: 1.9.0
> Reporter: mehran
> Attachments: 20.tar.gz
>
>
> I have a table with 300 columns.
> When I select a query , some null columns are also returned.
> This is the query that I used.
> "select a,b from dfs.root.`/2016/1/17` where a=1"
> For example in this query some columns are returned that "a" value is null.
> I think null values are problems. Because when I add a condition to it like
> "select a,b from dfs.root.`/2016/1/17` where a=1 and a IS NOT NULL"
> there is not any change and still NULL values are returned.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
