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

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

     [ https://issues.apache.org/jira/browse/CALCITE-4373?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Wang Yanlin closed CALCITE-4373.
--------------------------------
    Resolution: Duplicate

Same with https://issues.apache.org/jira/browse/CALCITE-4374

> 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
>            Priority: Major
>         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)