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
Post a Comment