hudi-bot opened a new issue, #15540: URL: https://github.com/apache/hudi/issues/15540
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" ); ``` ## JIRA info - Link: https://issues.apache.org/jira/browse/HUDI-5152 - Type: New Feature -- 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]
