incubator-doris branch 0.13 add paritition fail

mpbci0fu  于 2022-04-22  发布在  Java
关注(0)|答案(2)|浏览(256)

--- 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?

xpcnnkqh

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 .

z4iuyo4d

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?

相关问题