You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Xurenhe (Jira)" <ji...@apache.org> on 2021/09/18 23:04:00 UTC
[jira] [Comment Edited] (CALCITE-4779) GroupSet contains constant,
materialized view recognition failed
[ https://issues.apache.org/jira/browse/CALCITE-4779?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17417249#comment-17417249 ]
Xurenhe edited comment on CALCITE-4779 at 9/18/21, 11:03 PM:
-------------------------------------------------------------
Hi [~xzh_dz] [~julianhyde]
For current case.
I add `CoreRules.AGGREGATE_PROJECT_PULL_UP_CONSTANTS` to canonicalize query, it's passed.
!image-2021-09-19-06-41-52-352.png|width=579,height=312!
----
was (Author: wojustme):
Hi [~xzh_dz] [~julianhyde]
For current case.
I add `CoreRules.AGGREGATE_PROJECT_PULL_UP_CONSTANTS` to canonicalize query, it's passed.
!image-2021-09-19-06-41-52-352.png!
> GroupSet contains constant, materialized view recognition failed
> ----------------------------------------------------------------
>
> Key: CALCITE-4779
> URL: https://issues.apache.org/jira/browse/CALCITE-4779
> Project: Calcite
> Issue Type: Improvement
> Reporter: xzh_dz
> Priority: Major
> Attachments: image-2021-09-19-06-41-52-352.png
>
>
> {code:java}
> // code placeholder
> org.apache.calcite.test.MaterializedViewSubstitutionVisitorTest
> @Test void testCountDistinct() {
> final String mv = ""
> + "select \"deptno\", \"empid\"\n"
> + "from \"emps\"\n"
> + "group by \"deptno\", \"empid\"";
> final String query = ""
> + "select 1, \"deptno\"\n"
> + "from \"emps\"\n"
> + "group by 1, \"deptno\"";
> sql(mv, query).ok();
> }
> {code}
> Materialized view failed to be matched by optimized results:Materialized view failed to be matched by optimized results: java.lang.AssertionError: Materialized view failed to be matched by optimized results: at org.apache.calcite.test.AbstractMaterializedViewTest.checkMaterialize(AbstractMaterializedViewTest.java:116) at org.apache.calcite.test.AbstractMaterializedViewTest.access$000(AbstractMaterializedViewTest.java:67) at org.apache.calcite.test.AbstractMaterializedViewTest$Sql.ok(AbstractMaterializedViewTest.java:229) at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:627)
--
This message was sent by Atlassian Jira
(v8.3.4#803005)