Delete a line from a measurements whith a field in the where Or Create a tag as float on type

influxdb
#1

Hi everyone I’am just new at this Community I went to know how i can can Delete a line from a measurements whith a field in the where Or Create a tag as float on type

Thank’s Everyone

#2

Hi , welcome :slight_smile:

  • tags are always strings , you cannot create tags as other datatypes.
  • you cannot delete a line with a field in the where …

insert temp val=1
insert temp val=2
select * from temp
name: temp
time val
'---- —
1551178967354081839 1
1551178972240937434 2
delete from temp where val=1
ERR: shard 52: fields not supported in WHERE clause during deletion
delete from temp where time=1551178967354081839
select * from temp
name: temp
time val
'---- —
1551178972240937434 2

#3

Thank you MArc for your response,have a nice day