--- 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
selectdt
count(mid)
from xng_ma.dwm_show_test_2
group by dt
;
CREATE MATERIALIZED VIEW bitmap_dwm_show_test_2 as
selectdt
,
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?
2条答案
按热度按时间xpcnnkqh1#
#4342 Same as this issue. I already fix this issue in master branch by pr #4343 and #4408. You can use master branch directly.
According to "ERROR 2027 (HY000): Malformed packet" this error, this may be caused by the incompatibility between the client you are using and the result of desc. You can try this statement directly through the mysql-client .
z4iuyo4d2#
#4342 Same as this issue. I already fix this issue in master branch by pr #4343 and #4408. You can use master branch directly.
According to "ERROR 2027 (HY000): Malformed packet" this error, this may be caused by the incompatibility between the client you are using and the result of desc. You can try this statement directly through the mysql-client .
$ mysql --version
mysql Ver 14.14 Distrib 5.7.31, for Linux (x86_64) using EditLine wrapper
which version of mysql-client can be used for master branch?