Update large set of records

Anyone have a good , efficient strategy for updating 1m+ records values. Basically what I know is you have to reinsert. Is there anything else to consider? I get why influx doesn’t do updates but that really inconvenient when you need to do one.

Has anyone built a tool to pull data based on dates, modify the values (apply an adjustment or function) and re insert?

Best,