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 2021/10/02 10:25:26 UTC
[GitHub] [incubator-doris] qzsee opened a new issue #6790: [Bug] DUP Table doesn't Schema change
qzsee opened a new issue #6790:
URL: https://github.com/apache/incubator-doris/issues/6790
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues.
### Version
all version
### What's Wrong?
First, create a dup table `test`
```sql
CREATE TABLE `test` (
`a` bigint(20) NULL ,
`b` bigint(20) NULL ,
`c` bigint(20) NULL,
`d` bigint(20) NULL ,
`e` varchar(1) NULL,
`f` varchar(1) NULL
) ENGINE=OLAP
DUPLICATE KEY(`a`, `b`, `c`)
PARTITION BY RANGE(`a`, `d`)
(PARTITION p1 VALUES LESS THAN ("10", "10"))
DISTRIBUTED BY HASH(`d`,`b`) BUCKETS 10
PROPERTIES (
"replication_num" = "1"
);
```
Second, add rollup for `test`
```sql
alter table test add rollup r1(d,e,b,a);
```
Final, schema change for `test`
```sql
alter table test modify column e varchar(2);
ERROR 1064 (HY000): errCode = 2, detailMessage = Can not modify partition column[a]. index[r1]
```
Obviously, I changed field `e`, but I was reminded that partition field `a` cannot be changed, but I did not change partition field `a`.
Reason：
In table test, `a,b,c` are `keys`, `d,e,f` are `values`, but in rollup `r1`, `a,b` become `value`, `d,e` become `key`. When changing `e`, the partition field `a,d` is detected to see if it has been modified. It is obvious that the type of the partition field `a,d` has been changed implicitly
### What You Expected?
fix this problem
### How to Reproduce?
_No response_
### Anything Else?
_No response_
### Are you willing to submit PR?
- [X] Yes I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
--
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.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
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] yangzhg closed issue #6790: [Bug] DUP Table doesn't Schema change
Posted by GitBox <gi...@apache.org>.
yangzhg closed issue #6790:
URL: https://github.com/apache/incubator-doris/issues/6790
--
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.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
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] yangzhg closed issue #6790: [Bug] DUP Table doesn't Schema change
Posted by GitBox <gi...@apache.org>.
yangzhg closed issue #6790:
URL: https://github.com/apache/incubator-doris/issues/6790
--
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.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
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] qzsee closed issue #6790: [Bug] DUP Table doesn't Schema change
Posted by GitBox <gi...@apache.org>.
qzsee closed issue #6790:
URL: https://github.com/apache/incubator-doris/issues/6790
--
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.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
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