Querying: _time column as UNIX time

InfluxDB 2
1

Hi,

Currently when querying (using pythonAPI) the _time column has the time sent as a RFC3339 timestamps.
Is it possible to get it as UNIX time? that can save on the amount of data that needs to be transfered.
I see that reducing the amount of columns that are sent from influxDB to the python cliet saves a lot of time, thus I was thinking that reducing the amount of bytes the _time column has can also reduce the query time.

One way to do this would be to use map() with uint() and then drop the _time column, but I don’t know if it would be fast on a large query.

Any thoughts?

2

Hello @DavidHy,
Unfortunately, I don’t think that there is a way with the python client. I would try doing the conversion with Flux.