chxfantasy opened a new issue #4462:
URL: https://github.com/apache/incubator-doris/issues/4462
--- create table
CREATE table xng_ma.dwm_show_test_2 (
`dt` int COMMENT 'yyyyMMdd',
`mid` bigint COMMENT 'user id',
`aid` bigint COMMENT 'content id'
)
ENGINE = olap
DUPLICATE KEY(`dt`,`mid`, `aid`)
PARTITION BY range(`dt`) (
PARTITION dt20200817 VALUES [("20200817"),("20200818"))
)
DISTRIBUTED BY HASH(`dt`) BUCKETS 16
PROPERTIES (
"replication_num" = "3"
);
-- add material view
CREATE MATERIALIZED VIEW count_dwm_show_test_2 as
select
`dt`
count(mid)
from xng_ma.dwm_show_test_2
group by `dt`;
CREATE MATERIALIZED VIEW bitmap_dwm_show_test_2 as
select
`dt`,
bitmap_union(to_bitmap(mid)),
bitmap_union(to_bitmap(aid))
from xng_ma.dwm_show_test_2
group by `dt`;
-- add partition:
alter table xng_ma.dwm_show_test_2
ADD PARTITION IF NOT EXISTS dt20200818 values [("20200818"),("20200819"))
DISTRIBUTED BY HASH(`dt`) BUCKETS 32
PROPERTIES (
"replication_num" = "3"
);
doris come out with error:
ERROR 1064 (HY000): errCode = 2, detailMessage = Failed to create
partition[dt20200818]. Timeout. Unfinished mark: 10002=11121, 10002=11129,
10002=11137
i have see the log on be 10002, no 11121, 11129,11137 found.
I want to use the MATERIALIZED VIEW,
master branch do not have this error, but master branch can not desc
dwm_show_test_2 all, end in "ERROR 2027 (HY000): Malformed packet"
which version can i use?
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
