Support any_value rewrite when aggregate materialized view
Such as mv def sql is as following
select
o_orderdate,
any_value(l_partkey),
o_orderstatus,
l_suppkey,
any_value(l_suppkey),
any_value(o_orderstatus)
from lineitem_2
left join orders_2
on l_orderkey = o_orderkey and l_shipdate = o_orderdate
where l_partkey = 3
group by
o_orderstatus,
o_orderdate,
l_partkey,
l_suppkey;
the query like following can be rewritten scuucessfully by mv above
select
any_value(l_partkey),
any_value(l_suppkey),
any_value(o_orderstatus)
from lineitem_2
left join orders_2
on l_orderkey = o_orderkey and l_shipdate = o_orderdate
where l_partkey = 3 and o_orderstatus = 'o'
group by
o_orderdate,
l_suppkey;
Issue Number: close #xxx
Related PR: #xxx
Problem Summary:
Release note
Support any_value aggregate function rollup rewrite when exsits aggregate materialized view
Check List (For Author)
Test
[x] Regression test
[ ] Unit Test
[ ] Manual test (add detailed scripts or steps below)
[ ] No need to test or manual test. Explain why:
[ ] This is a refactor/code format and no logic has been changed.
What problem does this PR solve?
Support any_value rewrite when aggregate materialized view Such as mv def sql is as following
the query like following can be rewritten scuucessfully by mv above
Issue Number: close #xxx
Related PR: #xxx
Problem Summary:
Release note
Support any_value aggregate function rollup rewrite when exsits aggregate materialized view
Check List (For Author)
Test
Behavior changed:
Does this need documentation?
Check List (For Reviewer who merge this PR)