Saving EPOCH time value in user define column in influxDB -


i using influxdb , want write epoch time values in user define column shown below in v1 field.

cpu_load,host=server01,core=0 value=0.45,v1=1437171724 cpu_load,host=server01,core=0 value=0.45,v1=1437171725 

now, how can query column can query regular time based column

select * cpu_load v1 > '2016-08-31 00:42:24.000' 

this query not working, if switch v1 time column works fine.

select * cpu_load time > '2016-08-31 00:42:24.000' 

wondering how can use user define time/column value in influxdb?

influxdb supports field types of string, integer, float, , boolean.

the time column special case. though stored integer under hood, time field can filtered time based constraints.

there longstanding feature request allow comparison of fields time.

in meantime, raw integer epoch time value can used set constraint on v1 field. e.g.

select * "cpu_load" "v1" > 1472604144000 

Comments