seawinde opened a new pull request, #41674:
URL: https://github.com/apache/doris/pull/41674
## Proposed changes
Support rewrite by materialized view when join has other join conjuncts
Such as mv def is
```sql
select l_orderkey, o_orderdate
from
lineitem
inner join
orders on l_orderkey = o_orderkey and l_shipdate <= o_orderdate
inner join partsupp on ps_partkey = l_partkey and l_orderkey +
o_orderkey != ps_availqty;
```
The query can be rewtritten by mv sucessfully when has not equal conjuncts
in join
` l_shipdate <= o_orderdate` and `ps_partkey = l_partkey and l_orderkey +
o_orderkey != ps_availqty;`
```sql
select l_orderkey, o_orderdate
from
lineitem
inner join
orders on l_orderkey = o_orderkey and l_shipdate <= o_orderdate
inner join partsupp on ps_partkey = l_partkey and l_orderkey +
o_orderkey != ps_availqty;
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
