Hi, I tried to remove unwanted measurements from the InfluxDB database in this way:
SELECT * INTO "DistanceOk" FROM "Distance" WHERE value!=150 DROP measurement "Distance" SELECT * INTO "Distance" FROM "DistanceOk"
And I did some mess. As a result, I have additional field keys:
name_1_1 and the data are scattered all over them. Is there any way to keep the measurements and fix the base so that only the correct columns of