I’m trying to migrate data in order to perform some updates that are impossible in InflxuDB (e.g. convert tag to field, rename field, delete tag). To do that, I’m using SELECT … LIMIT with increasing OFFSETs. However, that gets slower and slower (from 0 seconds to 4 minutes when the offset is around 30M):
Worse, when the offset gets high enough,
Is there a workaround? Other than
SELECT INTO, which ended up corrupting my source measurement.