[jira] [Assigned] (CALCITE-4857) Materialization-Failed, query could be grouping mv's agg-call, when executing mv-match.

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

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

Xurenhe reassigned CALCITE-4857:
--------------------------------

    Assignee: Xurenhe

> Materialization-Failed, query could be grouping mv's agg-call, when executing mv-match.
> ---------------------------------------------------------------------------------------
>
>                 Key: CALCITE-4857
>                 URL: https://issues.apache.org/jira/browse/CALCITE-4857
>             Project: Calcite
>          Issue Type: Bug
>            Reporter: Xurenhe
>            Assignee: Xurenhe
>            Priority: Major
>              Labels: pull-request-available
>         Attachments: image-2021-10-18-11-18-02-312.png
>
>          Time Spent: 20m
>  Remaining Estimate: 0h
>
> Here, query could be rewritten by mv, but it's failed now.
> {code:java}
> -- mv: 
> select deptno, salary, min(commission) as commission_min 
> from emps 
> group by deptno, salary
> -- query: 
> select deptno, salary, max(salary), min(commission) 
> from emps 
> group by deptno, salary
> -- after mv match
> select deptno, salary, max(salary), commission_min
> from mv
> group by deptno, salary, commission_min
> {code}
>  
> !image-2021-10-18-11-18-02-312.png!  
>  



--
This message was sent by Atlassian Jira
(v8.20.1#820001)