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:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
