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/07/22 10:25:38 UTC
[GitHub] [incubator-doris] ZhangYu0123 opened a new issue #4142: Alter table add key column fails in agg module using LinkedSchemaChange policy
ZhangYu0123 opened a new issue #4142:
URL: https://github.com/apache/incubator-doris/issues/4142
**Describe the bug**
A clear and concise description of what the bug is.
When alter table add key column in agg module using LinkedSchemaChange policy, "ALTER, status_code: RUNTIME_ERROR" will be returned.
The error log as follows:
E0721 13:48:18.405797 34117 alpha_rowset.cpp:308] column pruning size is error.KeysType=AGG_KEYS, zone_maps_size=4, num_key_columns=5, num_columns=5
W0721 13:48:18.405853 34117 alpha_rowset_writer.cpp:227] rowset init failed when build new rowset, res=-402
**To Reproduce**
Steps to reproduce the behavior:
1. Create table
CREATE TABLE `table13` (
`siteid` varchar(64) NOT NULL COMMENT "",
`siteid2` varchar(64) NOT NULL COMMENT "",
`siteid3` varchar(64) NOT NULL COMMENT ""
) ENGINE=OLAP
AGGREGATE KEY(`siteid`, `siteid2`, `siteid3`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`siteid`) BUCKETS 1
PROPERTIES (
"replication_num" = "1",
"in_memory" = "false",
"storage_format" = "DEFAULT"
);
2. insert data
3. alter table add key column
alter table `table13` add column b int key default '0' after `siteid2`
4. See error
SHOW ALTER TABLE COLUMN;
**Expected behavior**
sucess
**Screenshots**
If applicable, add screenshots to help explain your problem.
----------------------------------------------------------------
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] yangzhg closed issue #4142: [BUG] Alter table add key column fails in agg module using LinkedSchemaChange policy
Posted by GitBox <gi...@apache.org>.
yangzhg closed issue #4142:
URL: https://github.com/apache/incubator-doris/issues/4142
----------------------------------------------------------------
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 #4142: [BUG] Alter table add key column fails in agg module using LinkedSchemaChange policy
Posted by GitBox <gi...@apache.org>.
EmmyMiao87 commented on issue #4142:
URL: https://github.com/apache/incubator-doris/issues/4142#issuecomment-694710527
Same issue: #4617
----------------------------------------------------------------
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