[CALCITE-4374] Support materialized view recognition when query distinct aggregate on target GROUP BY column

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.27.0
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Wang Yanlin
• Created: 03/Nov/20 08:33
• Updated: 01/Oct/21 09:32
• Resolved: 12/Nov/20 01:54

Description

When query distinct aggregate on the column, which is in the group by list of target.
Materialized view recognition should success.
See this case.

@Test void testQueryDistinctColumnInTargetGroupByList() {
    final String mv = ""
        + "select \"name\", \"deptno\" "
        + "from \"emps\" group by \"name\", \"deptno\"";
    final String query = ""
        + "select \"name\", count(distinct \"deptno\")\n"
        + "from \"emps\" group by \"name\"";
    sql(mv, query).ok();
  }

Issue Links

• is related to: CALCITE-4817 Expand SubstitutionVisitor of Aggregate with max/min, which column is the group by list of target
• links to: GitHub Pull Request #2241