melin created HUDI-5152:
---------------------------
Summary: Support aggregation model
Key: HUDI-5152
URL: https://issues.apache.org/jira/browse/HUDI-5152
Project: Apache Hudi
Issue Type: New Feature
Components: core
Reporter: melin
Refer to the aggregation model in apache doris：
https://doris.apache.org/docs/data-table/data-model#example-1-importing-data-aggregation
```sql
CREATE TABLE IF NOT EXISTS example_db.expamle_tbl
(
`user_id` LARGEINT NOT NULL COMMENT "user id",
`date` DATE NOT NULL COMMENT "data import time",
`city` VARCHAR(20) COMMENT "city",
`age` SMALLINT COMMENT "age",
`sex` TINYINT COMMENT "gender",
`last_visit_date` DATETIME REPLACE DEFAULT "1970-01-01 00:00:00" COMMENT "last
visit date time",
`cost` BIGINT SUM DEFAULT "0" COMMENT "user total cost",
`max_dwell_time` INT MAX DEFAULT "0" COMMENT "user max dwell time",
`min_dwell_time` INT MIN DEFAULT "99999" COMMENT "user min dwell time"
)
AGGREGATE KEY(`user_id`, `date`, `city`, `age`, `sex`)
DISTRIBUTED BY HASH(`user_id`) BUCKETS 1
PROPERTIES (
"replication_allocation" = "tag.location.default: 1"
);
```
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
