Menu
Is there any solution to remove a specific column of a series in InfluxDB?
Its seems that this feature is not implemented. But does anybody have found any kind of trick to do that?
868
Delete data using the influx CLIUse the influx delete command to delete points from InfluxDB. Use the --bucket flag to specify which bucket to delete data from. Use the --start and --stop flags to define the time range to delete data from. Use RFC3339 timestamps.
Delete series with DELETEThe DELETE query deletes all points from a series in a database. Unlike DROP SERIES , DELETE does not drop the series from the index. A successful DELETE query returns an empty result.
Delete a bucket in the InfluxDB UIIn the navigation menu on the left, select Load Data > Buckets. Find the bucket that you would like to delete. Click the icon located far right of the bucket name. Click Confirm to delete the bucket.
In InfluxDB, a series is a collection of points that share a measurement, tag set, and field key.
There is no way to delete a "column" (i.e. a field or a tag) from an Influx measurement. Here's the feature request for that.
You'll have to SELECT INTO a different measurement, excluding the columns you don't want:
SELECT useful_field, nice_tag INTO new_measurement FROM measurement
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
