[jira] [Created] (CALCITE-4373) Count(distinct Col) materialized view recognition failed

["xzh_dz (Jira)" <ji...@apache.org>]

xzh_dz created CALCITE-4373:
-------------------------------

             Summary: Count(distinct Col) materialized view recognition failed
                 Key: CALCITE-4373
                 URL: https://issues.apache.org/jira/browse/CALCITE-4373
             Project: Calcite
          Issue Type: Wish
            Reporter: xzh_dz
         Attachments: image-2020-11-03-10-56-57-804.png

 
{code:java}
org.apache.calcite.test.MaterializedViewSubstitutionVisitorTest
// code placeholder
@Test void testCountDistinctInAgg() {
  final String mv = ""
      + "select \"name\", \"commission\", \"deptno\"\n"
      + "from \"emps\" group by \"name\", \"commission\", \"deptno\"";
  final String query = ""
      + "select \"name\", \"commission\", count(distinct \"deptno\") as cnt\n"
      + "from \"emps\" group by \"name\", \"commission\"";
  sql(mv, query).withChecker(
      resultContains(""
          + "LogicalCalc(expr#0..1=[{inputs}], expr#2=['hello':VARCHAR], expr#3=[CAST($t0)"
          + ":VARCHAR], expr#4=[=($t2, $t3)], CNT=[$t1], $condition=[$t4])\n"
          + "  EnumerableTableScan(table=[[hr, MV0]])")).ok();
}
{code}
 

 

Error:

!image-2020-11-03-10-56-57-804.png|width=511,height=99!

 

 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)