Issue running ALTER TABLE on distributed tables

157 views
Skip to first unread message

Naveen Bandi

unread,
Dec 20, 2021, 10:55:21 PM12/20/21
to ClickHouse
Hi Everyone,

I have created distributed table on clickhouse cluster and trying to do ALTER DELETE on table but hitting this error, not sure if it is possible to perform ALTER DELETE on distributed table

Create table statement:
CREATE TABLE temp.books_preds_2
(
    `MarketID` Int16,
    `BooksId` Int16,
    `CardId` Int16,
)
ENGINE = Distributed('{cluster}', 'temp', 'books_preds_2_local', MarketID)

ALTER command:
ALTER TABLE temp.books_preds_2 ON CLUSTER '{cluster}' DELETE WHERE MarketID=1

Exception:
Received exception from server (version 21.8.8):
Code: 48. DB::Exception: Received from elb.amazonaws.com:9000. DB::Exception: There was an error on [chi-ch-01-est-0-1:9000]: Code: 48, e.displayText() = DB::Exception: Table engine Distributed doesn't support mutations (version 21.8.8.29 (official build)).


Any help would be greatly appreciated !!

Thanks
Naveen


Reply all
Reply to author
Forward
0 new messages