search

apache / doris-website

Apache Doris Website
https://doris.apache.org/
82 stars 232 forks source link

drop table my_table cannot be dropped #942

Open yuexin1028 opened 3 months ago

yuexin1028 commented 3 months ago

[HY000][1105] errCode = 2, detailMessage = errCode = 2, detailMessage = The table [my_table]'s state is SCHEMA_CHANGE, cannot be dropped. please cancel the operation on olap table firstly. If you want to forcibly drop(cannot be recovered), please use "DROP table FORCE".

KassieZ commented 1 month ago

Hi, thank you for the feedback, the engineer will fix it ASAP

morningman commented 1 month ago

This is by designed. When a table is under schema change(like add/drop/modify column), the table can not be dropped directly. If you insist, use Drop your_table force;