ebyhr commented on code in PR #11041: URL: https://github.com/apache/iceberg/pull/11041#discussion_r2875579143
########## format/view-spec.md: ########## @@ -322,3 +453,96 @@ s3://bucket/warehouse/default.db/event_agg/metadata/00002-(uuid).metadata.json } ] } ``` + +### Materialized View Example + +Imagine the following operation, which creates a materialized view that precomputes daily event counts: + +```sql +USE prod.default +``` +```sql +CREATE MATERIALIZED VIEW event_agg_mv ( + event_count COMMENT 'Count of events', + event_date) +COMMENT 'Precomputed daily event counts' +AS +SELECT + COUNT(1), CAST(event_ts AS DATE) +FROM events +GROUP BY 2 +``` + +The materialized view metadata JSON file looks as follows: + +``` +s3://bucket/warehouse/default.db/event_agg_mv/metadata/00001-(uuid).metadata.json +``` +``` Review Comment: This will improve the readability in the generated page: ```suggestion ```json ``` -- 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]
