[
https://issues.apache.org/jira/browse/CALCITE-6878?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17933631#comment-17933631
]
Zhen Chen commented on CALCITE-6878:
------------------------------------
[~rubenql] Yes, only contains sort fields can push down filter.
> Implement FilterSortTransposeRule
> ---------------------------------
>
> Key: CALCITE-6878
> URL: https://issues.apache.org/jira/browse/CALCITE-6878
> Project: Calcite
> Issue Type: New Feature
> Reporter: Zhen Chen
> Assignee: Zhen Chen
> Priority: Major
> Labels: pull-request-available
>
> Do we need this rule?
> from:
> {code:java}
> LogicalFilter(condition=[<($0, 10)])
> LogicalSort(sort0=[$0], dir0=[ASC])
> LogicalProject(EMPNO=[$0])
> LogicalTableScan(table=[[scott, EMP]]) {code}
> to:
> {code:java}
> LogicalSort(sort0=[$0], dir0=[ASC])
> LogicalFilter(condition=[<($0, 10)])
> LogicalProject(EMPNO=[$0])
> LogicalTableScan(table=[[scott, EMP]]) {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
