boluor opened a new pull request, #3670: URL: https://github.com/apache/doris-website/pull/3670
## Summary Fixes two code-example errors in the aggregate data model doc (`table-design/data-model/aggregate.md`): 1. **`example_tbl_agg` output mismatch** — the `SELECT * FROM example_tbl_agg` result header showed `last_visit_date` / `max_dwell_time`, but the table DDL defines those columns as `last_visit_dt` / `max_dwell`. Corrected the output header to match the DDL. 2. **`aggstate` non-existent columns** — the table `aggstate` is defined with columns `k1, v1, v2`, but the "retain intermediate results" section used non-existent `k2` / `k3` in `sum_union` / `sum_merge` / `group_concat_union` / `group_concat_merge`. Corrected to `v1` / `v2` (the earlier `merge` example already correctly uses `v2`). Applied across all affected versions (EN: next + 2.0/2.1/3.x/4.x; ZH: next + 2.1/3.x/4.x). ## Test plan - [x] Verified `example_tbl_agg` DDL column names vs the `SELECT *` output header - [x] Verified `aggstate` DDL columns (`k1, v1, v2`) vs the queries; `sum_*` maps to the `SUM` column `v1`, `group_concat_*` maps to the `agg_state<group_concat>` column `v2` - [x] Verified ASCII output-table alignment after the rename -- 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]
