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/10/16 08:32:08 UTC
[GitHub] [incubator-doris] wyndia opened a new issue #4753: [Bug] Can't add partitons to a table which has "colocate_with" property
wyndia opened a new issue #4753:
URL: https://github.com/apache/incubator-doris/issues/4753
**Describe the bug**
Version: Apache Doris 0.12.0-rc03
Using `ALTER TABLE` to add a partiton to tables with "colocate_with" property will fail.
**To Reproduce**
1. Create a table:
```SQL
CREATE TABLE `test` (
`date` date,
`userid` varchar(128)
) ENGINE=OLAP
DUPLICATE KEY(`date`, `userid`)
PARTITION BY RANGE(`date`)()
DISTRIBUTED BY HASH(`userid`) BUCKETS 8
PROPERTIES (
"colocate_with" = "test"
);
```
2. Try to add a partition:
```SQL
ALTER TABLE test add PARTITION p1 VALUES [("2020-10-15"), ("2020-10-16"));
```
3. See the error:
```SQL
ERROR 1064 (HY000): Unexpected exception: null
```
----------------------------------------------------------------
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] HappenLee commented on issue #4753: [Bug] Can't add partitons to a table which has "colocate_with" property
Posted by GitBox <gi...@apache.org>.
HappenLee commented on issue #4753:
URL: https://github.com/apache/incubator-doris/issues/4753#issuecomment-717672724
@wyndia Hi,I check this problem. because you create table with empty partition of `date`, this cause the colocatebalancer get null pointer.
it is easy to avoid this bug:
1. create table with unless one valid partition. do not empty partition and add partition later
2. use dynamic_partition.
----------------------------------------------------------------
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] morningman commented on issue #4753: [Bug] Can't add partitons to a table which has "colocate_with" property
Posted by GitBox <gi...@apache.org>.
morningman commented on issue #4753:
URL: https://github.com/apache/incubator-doris/issues/4753#issuecomment-717674423
> @wyndia Hi,I check this problem. because you create table with empty partition of `date`, this cause the colocatebalancer get null pointer.
>
> it is easy to avoid this bug:
>
> 1. create table with unless one valid partition. do not empty partition and add partition later
> 2. use dynamic_partition.
i think this is a bug, we should fix it
----------------------------------------------------------------
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 #4753: [Bug] Can't add partitons to a table which has "colocate_with" property
Posted by GitBox <gi...@apache.org>.
EmmyMiao87 commented on issue #4753:
URL: https://github.com/apache/incubator-doris/issues/4753#issuecomment-717672265
The main reason for this is because your partition does not specify a range, so it is not a partitioned table
----------------------------------------------------------------
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