DongTL opened a new issue #5756:
URL: https://github.com/apache/incubator-doris/issues/5756
**Describe the bug**
按照官网指南中的说明，使用
```
ALTER TABLE table1 ADD COLUMN uv BIGINT SUM DEFAULT '0' after pv;
```
对表结构进行修改。
使用
```
SHOW ALTER TABLE COLUMN;
```
查看任务情况
```
+-------+-----------+---------------------+------------+-----------+---------+---------------+---------------+---------------+---------+-------------------+----------+---------+
| JobId | TableName | CreateTime | FinishTime | IndexName | IndexId
| OriginIndexId | SchemaVersion | TransactionId | State | Msg |
Progress | Timeout |
+-------+-----------+---------------------+------------+-----------+---------+---------------+---------------+---------------+---------+-------------------+----------+---------+
| 10047 | table1 | 2021-05-06 14:56:43 | NULL | table1 | 10048
| 10010 | 1:120497433 | -1 | PENDING | table is unstable |
NULL | 86400 |
+-------+-----------+---------------------+------------+-----------+---------+---------------+---------------+---------------+---------+-------------------+----------+---------+
```
该任务一直pending
使用
```
CANCEL ALTER TABLE COLUMN FROM table1;
```
取消任务，提示
```
ERROR 1064 (HY000): errCode = 2, detailMessage = Table[table1] is not under
SCHEMA_CHANGE.
```
希望各位解答。
- Version: Doris 0.13.0
--
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]
