You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2020/08/26 18:41:44 UTC
[GitHub] [incubator-doris] chxfantasy opened a new issue #4462: branch 0.13 add paritition fail
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] chxfantasy commented on issue #4462: branch 0.13 add paritition fail
Posted by GitBox <gi...@apache.org>.
chxfantasy commented on issue #4462:
URL: https://github.com/apache/incubator-doris/issues/4462#issuecomment-682482102
> #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?
----------------------------------------------------------------
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] EmmyMiao87 commented on issue #4462: branch 0.13 add paritition fail
Posted by GitBox <gi...@apache.org>.
EmmyMiao87 commented on issue #4462:
URL: https://github.com/apache/incubator-doris/issues/4462#issuecomment-681390696
#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 .
----------------------------------------------------------------
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org