How to delete columns of a series in InfluxDB

database time-series influxdb
Darko P. picture Darko P. · Nov 5, 2014 · Viewed 8.6k times · Source

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?

Answer

Dan Dascalescu picture Dan Dascalescu · Sep 26, 2016

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

Related questions

Storing time-series data, relational or non?

I am creating a system which polls devices for data on varying metrics such as CPU utilisation, disk utilisation, temperature etc. at (probably) 5 minute intervals using SNMP. The ultimate goal is to provide visualisations to a user of the system …

Read More
Is there a powerful database system for time series data?

In multiple projects we have to store, aggregate, evaluate simple measurement values. One row typcially consists of a time stamp, a value and some attributes to the value. In some applications we would like to store 1000 values per second and …

Read More
What is the best open source solution for storing time series data?

I am interested in monitoring some objects. I expect to get about 10000 data points every 15 minutes. (Maybe not at first, but this is the 'general ballpark'). I would also like to be able to get daily, weekly, monthly and yearly …

Read More