sql - Can you delete data from influxdb? -


How do you delete data from influxdb?

Documentation indicates that it should be as simple as:

  Remove from foo where time & lt; For some reasons, influxdb rejected my deleted statement and said "Delete queries can not be where segment is not reference"  
  select * From bootstrap to where duration & gt; 1000 and time & gt; 14041409940 and time & lt; Now ()   

Which period of these 5 entries I & gt; Wants to delete 1000 seconds

Enter image details here

It should be a valid SQL statement, yet it fails

Image Details Here Enter

None of these deleted statements either work Remove from bootstrap where the period & gt; Removing the 3000000 "Bootstrap from the period where the period> 300000" from the bootstrap, where the time = 1404140994043 "Remove from bootstrap where the duration> 300000 and time> 1404141054508" remove from bootstrap where the period & gt; 300000 and time & gt; 1404141054508 "Remove from bootstrap, where time> 1404141054508 and duration> 300000" remove from bootstrap, where duration & gt; 30000 and time & gt;

Delete from the pre- bootstrap, where time> 1404141416824 and duration> 3000; Remove the sequence_number from the bootstrap, where time> 1s and duration> gt; 1000;

Maybe this bug?


It appears that you It can do in influxdb 0.9 For example, here is a query that was successful only for me:

  drop down The temperature from the ridge is WHERE machine = 'zagbar'   

(by every liberal comment @morta corlu, I am posting my previous comment as an answer ...) < / P>

Comments

Popular posts from this blog

php - PDO bindParam() fatal error -

logging - How can I log both the Request.InputStream and Response.OutputStream traffic in my ASP.NET MVC3 Application for specific Actions? -

java - Why my included JSP file won't get processed correctly? -