Flux copy and rename measurement

InfluxDB 2
, ,
1

Hello,
Is there a way to change the measurement of a particular tag?

For example, I’ve got measurement “type-a” with tags abc,def,ghi. I would like to select all entries for def into measurement “type-b”

Thanks in advance

2

@t481, you can use Flux to output for writing selected data to a different place.
However, it will copy data. You have to delete data manually using the CLI client or write a custom app using a client library.
AFAIK, it is not possible to delete data in Flux.

1 Like
3

Hello @VlastaHajek,
Thanks for your answer
You can use the CLI to delete data:

4

Thanks @VlastaHajek but how do you change the measurement name itself?

5

@VlastaHajek for renaming I believe we will have to copy entire data. I am trying to do the same, but its gives error.

from(bucket: "dsb_retention_30d")
                |> range(start: -30d)
                |> filter(fn: (r) => r["_measurement"] == "Supply")
                |> set(key: "_measurement", value: "tanuj")
                |> to(bucket: "dsb_retention_90d", org: "Intuit")

Also were you able to use influx cli to run this? If yes, can you please help me with same.