seawinde opened a new pull request, #38909:
URL: https://github.com/apache/doris/pull/38909
## Proposed changes
mv def is
```sql
select l_orderkey, l_partkey, o_custkey, l_shipdate, o_orderdate
from ${hive_catalog_name}.${hive_database}.${hive_table}
left join ${internal_catalog}.${olap_db}.${olap_table} on
l_orderkey = o_orderkey
```
if we query the sql as following, it will rewrite fail by mv, the fail info
is `mv can not offer any partition for query`
```sql
select l_orderkey, l_partkey, o_custkey, l_shipdate, o_orderdate
from ${hive_catalog_name}.${hive_database}.${hive_table}
left join ${internal_catalog}.${olap_db}.${olap_table} on
l_orderkey = o_orderkey
```
This pr fix this problem. it will rewrite by mv successfully.
--
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: commits-unsubscr...@doris.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
