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: idx_1 idx_1_1 name_1 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 idx and name remain?
