Hello,
I have following configuration in my influxDB account :
I have 4 bucket which are bucket_A, bucket_B, bucket_C and bucket_D.
In my bucket_A, i have 3 _measurements which are measure_A, measure_B and measure_C.
In my measure_A, i have 5 _field : name, age, email, address, number
I want to delete _field “name” in measure_A in bucket_A.
I didn’t understand influxDB documententation about the command i need to enter in my script editor in influxdata.
Could you help me please ? I work with influxDB 2.0
Hi @Kevin_Boudigues,
Deletions like this is sadly not something you can achieve via the script editor. It is an API only feature and does not allow you to get this granular with your deletion:
Delete data | InfluxDB Cloud Documentation.
You would be deleting points rather than dropping a column like you are expecting.
Another route you could take is by writing your dataset to a new bucket and dropping the name column before hand:
from(bucket: "plantbuddy")
|> range(start: -30d)
|> filter(fn: (r) => r._measurement == "sensor_data")
|> drop(columns: ["name"])
|> to(bucket: "new_bucket")
It also looks like your data in this bucket might be better off in a reletional database. You could store it there and join your reletional data and time series data during query time with the SQL packages:
