You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "xzh_dz (Jira)" <ji...@apache.org> on 2020/11/03 02:59:00 UTC
[jira] [Created] (CALCITE-4373) Count(distinct Col) materialized
view recognition failed
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)