[CALCITE-3880] Add SortExchange support to RelFieldTrimmer

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.21.0
• Fix Version/s: 1.23.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Krisztian Kasa
• Reporter: Krisztian Kasa
• Created: 27/Mar/20 07:51
• Updated: 24/May/20 11:59
• Resolved: 02/Apr/20 19:29

Description

LogicalProject(EMPNO=[$0])
  LogicalSortExchange(distribution=[hash[1]], collation=[[0]])
    LogicalProject(EMPNO=[$0], ENAME=[$1], DEPTNO=[$7])
      LogicalTableScan(table=[[scott, EMP]])

In this case the column `DEPTNO` is not required in LogicalSortExchange nor in the Project top on it.

Issue Links

• links to: GitHub Pull Request #1879