[CALCITE-312] Need PushProjectThroughWindowRel

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Assignee: Unassigned
• Reporter: Vladimir Sitnikov
• Created: 25/Jun/14 20:28
• Updated: 22/Feb/19 01:22

Description

Currently optiq does not push projects through WindowRel, thus it feeds excessive data to WindowRel.

select *
  from (
    select "empid", "deptno", count(*) over (partition by "deptno") c
      from "hr"."emps"
 )
 where "deptno"=10 and "empid"=100

Optiq should recognize it is required to track just fields empid and deptno.

However the java code is as follows (note that empid, name, salary, and commission are projected):

/*  47 */       _list.add(new Object[] {
/*  48 */         row.empid,
/*  49 */         row.deptno,
/*  50 */         row.name,
/*  51 */         row.salary,
/*  52 */         row.commission,
/*  53 */         COUNTa0w0});