drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "mehran (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (DRILL-5201) Query bug: null values in result of a conditioned query
Date Thu, 19 Jan 2017 09:43:26 GMT

    [ 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)

Mime
View raw message