Hello fellow influxdb users!
I have made a foolish mistake by changing the fields within a measurement.
Example:
Up to a point I stored the data in a measurement with fields like this:
Timestamp; key; value
= = = = = = = = = = = =
Timestamp; key1; value
Timestamp; key2; value
Timestamp; key3; value
Timestamp; key1; value
Timestamp; key2; value
Timestamp; key3; value
…
This worked fine and I filtered the results with a e.g. WHERE “Key”=‘Key1’ Statement.
After some time, I changed it to this:
Timestamp; Key1;Key2;Key3
= = = = = = = = = = = = = = = =
Timestamp; value;value;value
Timestamp; value;value;value
…
Which worked even better for my case.
I was assuming the old fields (or colums) would just stay in the measurement forever so I could access them if I needed the older data. I now learned that this isn’t the case and that they disappear after a week, propably when the shards get reorganised.
Even “show field keys” doesnt show the old keys anymore.
If I do a complete dump of the measurement via influx_inspect, I can see the data is still there, but it is a futile attempt, at least for me, to recover them from there, its a 500 MB file with millions lines of lineprotocol.
Can anyone give me an idea how I could extract this “hidden” data from the measurement?
