apache / doris

Apache Doris is an easy-to-use, high performance and unified analytics database.
https://doris.apache.org
Apache License 2.0
12.65k stars 3.26k forks source link

branch 0.13 add paritition fail #4462

Open chxfantasy opened 4 years ago

chxfantasy commented 4 years ago

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

EmmyMiao87 commented 4 years ago

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 .

chxfantasy commented 4 years ago

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?