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)