```2023 03 14T17 45 29 125713Z C i q c h p JsonQueryProcesso

Question

```2023 03 14T17 45 29 125713Z C i q c h p JsonQueryProcessorState 3009 error q=`ALTER TABLE binance dc DETACH PARTITION LIST 2023 03 13 ` msg=`could not detach partition table=binance dc detachStatus=DETACH ERR ACTIVE partitionTimestamp=2023 03 13T00 00 00 000Z partitionBy=DAY ` errno= 100 ```

Imre · Answer

hi < Franco Almonacid> i think the error `DETACH ERR ACTIVE` suggests that the partition is still active so cannot be detached

Imre · Answer

i see that the table is partitioned by DAY so not sure how yesterday s partition can still be active maybe there is no data for `2023 03 14` in the table so `2023 03 13` is the last and active partition

Franco Almonacid · Answer

Hi < Imre> that s right there is no data for the `2023 03 14` partition

Franco Almonacid · Answer

we managed to remove the `2023 03 13` partition using `DROP PARTITION` instead of `DETACH PARTITION`

Franco Almonacid · Answer

as we just wanted to delete the data

Imre · Answer

+1