[jira] [Created] (DRILL-2081) Filter not being pushed down into the sub query when we use flatten

["Rahul Challapalli (JIRA)" <ji...@apache.org>]

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)