[CALCITE-3310] Approximate and exact aggregate calls are recognized as the same during sql-to-rel conversion

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.20.0
• Fix Version/s: 1.21.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Danny Chen
• Reporter: Danny Chen
• Created: 30/Aug/19 07:27
• Updated: 10/Sep/19 21:37
• Resolved: 31/Aug/19 06:26

Description

For sql:

SELECT empno, count(distinct ename)
approx_count_distinct(ename)
FROM emp
GROUP BY empno

After sql-to-rel conversion, the plan is:

LogicalProject(EMPNO=[$0], EXPR$1=[$1], EXPR$2=[$1])
  LogicalAggregate(group=[{0}], EXPR$1=[COUNT(DISTINCT $1)])
    LogicalProject(EMPNO=[$0], ENAME=[$1])
      LogicalTableScan(table=[[CATALOG, SALES, EMP]])

Issue Links

• links to: GitHub Pull Request #1423