kangkaisen commented on issue #332: Adding ROLLUP result in Doris All BE core dump URL: https://github.com/apache/incubator-doris/issues/332#issuecomment-440661792 This bug could reproduce stably. 1 create table: ``` CREATE TABLE `table_test_palo_detail` ( `user_id` int(11) , `date` varchar(256) , `timestamp` varchar(256), `age` int(11), `sex` int(11) , `last_visit_date` varchar(256) REPLACE , `cost` int(11) SUM, `max_dwell_time` int(11) MAX , `min_dwell_time` int(11) MIN ) ENGINE=OLAP AGGREGATE KEY(`user_id`, `date`, `timestamp`, `age`, `sex`) DISTRIBUTED BY HASH(`user_id`) BUCKETS 10 PROPERTIES ( "storage_type" = "COLUMN", "replication_num" = "3" ); ``` 2 load some data ``` 1003 2017-10-02 2017-10-02 13:15:00 32 0 2017-10-02 11:20:00 30 11 11 1002 2017-10-02 2017-10-02 13:10:00 20 1 2017-10-02 12:59:12 200 5 5 1004 2017-10-01 2017-10-01 12:12:48 35 0 2017-10-01 10:00:15 100 3 3 1004 2017-10-03 2017-10-03 12:38:20 35 0 2017-10-03 10:20:22 11 6 6 1000 2017-10-01 2017-10-01 08:00:05 20 0 2017-10-11 06:00:00 20 10 10 1000 2017-10-01 2017-10-01 09:00:05 20 0 2017-10-11 07:00:01 15 2 2 1001 2017-10-01 2017-10-01 18:12:10 30 1 2017-10-11 05:05:43 2 22 22 ``` 3 add roll up ``` ALTER TABLE table_test_palo_detail ADD ROLLUP table_test_palo_detail_rollup(user_id,dat e,cost) ```
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
