drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jinfeng Ni (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-2081) Filter not being pushed down into the sub query when we use flatten
Date Fri, 06 Feb 2015 19:30:35 GMT

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

Jinfeng Ni commented on DRILL-2081:
-----------------------------------

s.evnts.type = 'cmpgn4' can not pushed into subquery, since the column comes from FLATTEN
operator.

Are you expecting that filter of s.type = 'web' is pushed down?

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

Mime
View raw message