Rahul Challapalli created DRILL-2081: ----------------------------------------
Summary: Filter not being pushed down into the sub query when we use flatten Key: DRILL-2081 URL: https://issues.apache.org/jira/browse/DRILL-2081 Project: Apache Drill Issue Type: Bug Components: Query Planning & Optimization Reporter: Rahul Challapalli Assignee: Jinfeng Ni Priority: Minor git.commit.id.abbrev=3c6d0ef The plan indicates that the query is not being pushed down into the subquery {code} 0: jdbc:drill:schema=dfs.drillTestDir> explain plan for select s.evnts.evnt_id from (select d.type type, flatten(d.events) evnts from `data.json` d) s where s.evnts.type = 'cmpgn4' and s.type='web'; +------------+------------+ | text | json | +------------+------------+ | 00-00 Screen 00-01 Project(EXPR$0=[ITEM($1, 'evnt_id')]) 00-02 SelectionVectorRemover 00-03 Filter(condition=[AND(=(ITEM($1, 'type'), 'cmpgn4'), =($0, 'web'))]) 00-04 Project(type=[$1], evnts=[$2]) 00-05 Flatten(flattenField=[$2]) 00-06 Project(EXPR$0=[$0], EXPR$1=[$1], EXPR$2=[$0]) 00-07 Scan(groupscan=[EasyGroupScan [selectionRoot=/drill/testdata/flatten_operators/data.json, numFiles=1, columns=[`type`, `events`], files=[maprfs:/drill/testdata/flatten_operators/data.json]]]) {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)