Can we delete column and add new column on existing measurement?

Hi,

Can we delete column and add new column on existing measurement?

I need to do this in my application.

Influx version - OSS 2.0
Language - Flux

Any help will be appreciated.

Hello @debnath,
You can use the rename(), set(), or map() function to effectively do this with Flux in a task

However this transformation work will only be applied to new incoming data. Tasks can’t operate on historical data.

The best way to transform or update historical data is to create an external script that iterates through the full range of your data in small batches and applies the changes in a query and writes the new data with the to() function.

Does that help?