[ https://issues.apache.org/jira/browse/DRILL-5237?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15856890#comment-15856890 ]
Chun Chang commented on DRILL-5237: ----------------------------------- added automation coverage. > 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)