seawinde opened a new pull request, #37929:
URL: https://github.com/apache/doris/pull/37929
## Proposed changes
Support variants rewrite by materialized view
Such as the mv def is as following:
> CREATE MATERIALIZED VIEW test1 BUILD IMMEDIATE REFRESH AUTO ON MANUAL
> DISTRIBUTED BY RANDOM BUCKETS 2
> PROPERTIES ('replication_num' = '1')
> as
> SELECT
> id,
> type,
> actor,
> payload,
> payload['pull_request']
> FROM github_events1;
the query following can rewrite successfully and the data is right
> SELECT
> id,
> type,
> floor(cast(actor['id'] as int) + 100.5),
> actor['display_login'],
> payload['pull_request']['id']
> FROM github_events1;
--
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
