[GitHub] [incubator-doris] morningman opened a new issue #1972: Add KEY column return 'Can not modify partition column'

[GitBox <gi...@apache.org>]

morningman opened a new issue #1972: Add KEY column return 'Can not modify partition column'
URL: https://github.com/apache/incubator-doris/issues/1972
 
 
   **Describe the bug**
   ```
   CREATE TABLE `rtition_schema_change_rollup_test_change_partition_rollup_tb_dul` (
     `k1` int(11) NOT NULL COMMENT "",
     `k2` int(11) NOT NULL COMMENT "",
     `v1` varchar(4096) NOT NULL COMMENT "",
     `v2` float NOT NULL COMMENT "",
     `v3` decimal(20, 7) NOT NULL COMMENT ""
   ) ENGINE=OLAP
   DUPLICATE KEY(`k1`, `k2`)
   PARTITION BY RANGE(`k1`)
   (PARTITION partition_a VALUES LESS THAN ("5"),
   PARTITION partition_b VALUES LESS THAN ("30"),
   PARTITION partition_c VALUES LESS THAN ("100"),
   PARTITION partition_d VALUES LESS THAN ("500"),
   PARTITION partition_e VALUES LESS THAN ("1000"),
   PARTITION partition_f VALUES LESS THAN ("2000"),
   PARTITION partition_g VALUES LESS THAN MAXVALUE)
   DISTRIBUTED BY HASH(`k1`, `k2`) BUCKETS 5
   PROPERTIES (
   "storage_type" = "COLUMN"
   );
   
   ALTER TABLE rtition_schema_change_rollup_test_change_partition_rollup_tb_dul ADD ROLLUP tion_schema_change_rollup_test_change_partition_rollup_index (k1,v1) duplicate key(k1)
   
   alter table rtition_schema_change_rollup_test_change_partition_rollup_tb_dul add column v4 float NULL to tion_schema_change_rollup_test_change_partition_rollup_index; 
   ```
   
   That last command return error:
   ```
   ERROR 1064 (HY000): Can not modify partition column[k1]. index[tion_schema_change_rollup_test_change_partition_rollup_index]
   ```
   
   **Why**
   
   This is because Doris wrongly set the `isAggregationTypeImplicit` to true for the column `k1` in rollup index.

----------------------------------------------------------------
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


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org