I am doing POC on influx db and i can see that if i am trying to drop measurement then all the data from the measurement has been deleted bu the old fields still remains there.
I want to delete the old fields how i can do this ?
As of April 2023, this is not possible (not easy, convenient, or safe, anyway) with the tools that Influx provides. However, at the end of the day, the data is just stored in files that can be manipulated once the Influx service is down.
I recommend trying some reputable third-party tools or extensions. One that I stumbled across was Infix, from ABC Arbitrage. This repository provides a command-line tool to rename, remove, and modify columns on Influx database files. The drawback is that it requires stopping the Influx service, so if you have a system that is not tolerant of downtime, you may still be out of luck.
It was already answered: How to delete columns of a series in InfluxDB
You can't.
Here is a feature request for this and some workarounds: https://github.com/influxdata/influxdb/issues/6150