drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-5237) FlattenRecordBatch loses nested fields from the schema when returns empty batches for the first time
Date Sat, 04 Feb 2017 03:59:52 GMT

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

ASF GitHub Bot commented on DRILL-5237:
---------------------------------------

Github user asfgit closed the pull request at:

    https://github.com/apache/drill/pull/735


> FlattenRecordBatch loses nested fields from the schema when returns empty batches for
the first time
> ----------------------------------------------------------------------------------------------------
>
>                 Key: DRILL-5237
>                 URL: https://issues.apache.org/jira/browse/DRILL-5237
>             Project: Apache Drill
>          Issue Type: Bug
>            Reporter: Serhii Harnyk
>            Assignee: Serhii Harnyk
>              Labels: ready-to-commit
>         Attachments: test_data.tar.gz
>
>
> Query 
> {code:sql}
> select count(*) as col from (select t1.a.a1 from (select t.*, flatten(t.b) as b from
dfs.`/tmp/test_data` t where t.c is not null) t1 where t1.a .a1 like 'a1');
> {code}
> returns different results for different values for option planner.width.max_per_node
> With options 
> {code:sql}
> alter session set `planner.slice_target` = 1;
> alter session set `planner.width.max_per_node` = 1;
> {code}
> query returns correct result:
> {noformat}
> +------+
> | col  |
> +------+
> | 3    |
> +------+
> {noformat}
> but with options 
> {code:sql}
> alter session set `planner.slice_target` = 1;
> alter session set `planner.width.max_per_node` = 3;
> {code}
> the same query returns wrong result 
> {noformat}
> +------+
> | col  |
> +------+
> | 2    |
> +------+
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message