database - Cannot DETACH partition using QuestDB REST API - Stack Overflow

I can run this query just fine from the web console or using psycopg from python

ALTER TABLE events DETACH PARTITION WHERE timestamp < dateadd('M', -8, date_trunc('day', now()))

But when I try invoking the API directly I get an error: method is not allowed

curl -X POST ":9000/exec" --data-urlencode "query=ALTER TABLE events DETACH PARTITION WHERE timestamp < dateadd('M', -8, date_trunc('day', now()))"

I can run this query just fine from the web console or using psycopg from python

ALTER TABLE events DETACH PARTITION WHERE timestamp < dateadd('M', -8, date_trunc('day', now()))

But when I try invoking the API directly I get an error: method is not allowed

curl -X POST "http://questdb.default.svc.cluster.local:9000/exec" --data-urlencode "query=ALTER TABLE events DETACH PARTITION WHERE timestamp < dateadd('M', -8, date_trunc('day', now()))"

• database
• time-series
• questdb

Share Improve this question Follow asked Jan 30 at 17:18 Javier RamirezJavier Ramirez 4,09511 gold badge2727 silver badges3636 bronze badges

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

This was an easy one! The /exec endpoint expects a GET request, unlike the imp endpoint which expects a POST.

curl -G "http://questdb.default.svc.cluster.local:9000/exec" --data-urlencode "query=ALTER TABLE events DETACH PARTITION WHERE timestamp < dateadd('M', -8, date_trunc('day', now()))"