seawinde opened a new pull request, #36175: URL: https://github.com/apache/doris/pull/36175
## Proposed changes This is brought by https://github.com/apache/doris/pull/35562 At the pr above when you create partition materialized view as following, which would fail with the message `Unable to find a suitable base table for partitioning`: > > CREATE MATERIALIZED VIEW mvName > BUILD IMMEDIATE REFRESH AUTO ON MANUAL > partition by (date_trunc(month_alias, 'month')) > DISTRIBUTED BY RANDOM BUCKETS 2 > PROPERTIES ( > 'replication_num' = '1' > ) > AS > SELECT date_trunc(`k2`,'day') as month_alias, k3, count(*) > FROM tableName group by date_trunc(`k2`,'day'), k3; > This pr supports to create partition materialized view when `date_trunc` in group by cluause. -- 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]
