citus:truncate records of a table

Question

I want to use sql command truncate table to truncate all records in a distributed table of citus,but seems it doesn't work,so I have to login to each datanode to truncate each shard of the table. so, can i use truncate table to delete all records in a distuributed table? my citus version is 10.0.3.

I have used sql command truncate table try to truncate all records in a distributed table of citus,but seems it doesn't work

score 0 · Answer 1 · edited Mar 27 '23 at 14:16

0

It should be possible to TRUNCATE a distributed table by running:

TRUNCATE TABLE distributed_table;

against the coordinator node.

edited Mar 27 '23 at 14:16

avariant

2,234
5
25
33

answered Mar 21 '23 at 13:33

Emel Hasdal

1
1

citus:truncate records of a table

1 Answers1