Hey guys, Somewhat new to influxdb and I was wondering is there a TRUNCATE like command at all? I have an influxdb I want to truncate and completely reset to an empty state on a deployment of some new code. Only way I can see to make this happen is via a drop and create however this causes issues …

Hi, I am not aware of any. But does not mean a thing because I am new here :wink: What I currently use is “DELETE FROM [MEASUREMENT_NAME]” You should know all measurements you use. Otherwise a “SHOW MEASUREMENTS” will tell you. Best regards Keith

Hello @lukekhamilton , Thank you for your question. You can drop a database or delete a series. Since InfluxDB is an append-only DB, it doesn’t have as many management commands as SQL. Please take a look at the InfluxDB docs here .

Hi @Anaisdg , DELETE and TRUNCATE are only for InfluxQL? Are there any equivalent for Flux, since I presume that is the only query language for InfluxDB 2.0. There is the drop() function for Flux, but I tried the following and it is not working for me. The data is still there: from(bucket: “aq-raw”…

TRUNCATE like command?

Systems

Anaisdg October 25, 2019, 10:09pm 5

Hey @Kevin-Chen0,
Please take a look at this other community question for your answer. Thanks!

Topic		Replies	Views
Delete measurements by name from bucket InfluxDB 2 client-libraries , flux	4	10083	July 1, 2020
Drop series or delete with influxdb v2.0.1 InfluxDB 2	3	3211	November 24, 2020
Error: not implemented: DROP SERIES InfluxDB 2 influxql	2	1201	October 23, 2022
Drop measurement (label) influxdb 2.0 InfluxDB 2	4	1223	March 20, 2022
InfluxDB Cloud - Drop Measurement / Column Systems	0	926	February 4, 2021

TRUNCATE like command?

Related topics