These are chat archives for influxdata/influxdb

16th
May 2016
Deepak
@deepujain
May 16 2016 19:07
How do make a CQ to run perdiodically
SELECT count(distinct(eId)) as units INTO channelIdAlerts FROM ep."default".epdetail WHERE time > now() - 120d GROUP BY time(1d), channelId fill(none)
Deepak
@deepujain
May 16 2016 21:06
I did this

CREATE CONTINUOUS QUERY bualerts ON ep RESAMPLE EVERY 1m BEGIN SELECT count(distinct(eId)) AS units INTO ep."default".bualerts FROM ep."default".epdetail WHERE time > now() - 120d GROUP BY time(1d), businessUnit fill(none) END

drop measurement bualerts
select from bualerts
select
from bualerts

and it never ran after a minute
any suggestions ?