Flux: InfluxDB conversion of a table from Float to Integer

Question

Using InfluxQL with this query, one could convert a table from Float to Integer:

SELECT value::integer INTO temp FROM measurement;
DROP MEASUREMENT measurement;
SELECT value::integer INTO measurement FROM temp;
DROP MEASUREMENT temp;

How can the same be done using Flux in InfluxDB 2?

InfluxDB 2 has an InfluxDB 1 compatibility layer, but this doesn't support SELECT ... INTO ... clauses: https://docs.influxdata.com/influxdb/v2.1/reference/api/influxdb-1x/#influxql-support So one does have to write the query using Flux, the new query language.

Stefan · Answer 1 · 2021-12-07T10:07:25.987

Create a temp bucket
run this query:

from(bucket: "<bucket>")
  |> range(start: 1970-01-01T00:00:00Z, stop: now())
  |> filter(fn: (r) => r["_measurement"] == "<measurement>")
  |> filter(fn: (r) => r["_field"] == "value")
  |> toInt()
  |> to(bucket: "temp", org: "<org>")

drop <measurement> in <bucket> via commandline:

influx delete --bucket <bucket> --start '2010-01-01T00:00:00Z' --stop $(date +"%Y-%m-%dT%H:%M:%SZ") --predicate '_measurement="<measurement>"' --org <org> --token <token>

run this query:

from(bucket: "temp")
  |> range(start: 1970-01-01T00:00:00Z, stop: now())
  |> filter(fn: (r) => r["_measurement"] == "<measurement>")
  |> filter(fn: (r) => r["_field"] == "value")
  |> to(bucket: "<bucket>", org: "<org>"

repeat from 2. for all measurements you want to convert
drop temp bucket

Flux: InfluxDB conversion of a table from Float to Integer

1 Answers1