We have some data that we would like to subsample without any modifications to the data. What's needed is to simply drop the data between certain intervals.
There are 3 retention policies. The one consuming the values (30 day retention, 10Hz samples) and two other subsamples (1 year retention, 10s samples 5ms offset; INF retention, 3 minute samples 5ms offset). It seems that all queries with GROUP BY time(...) require an aggregate function to operate. Is there a means to collect a subsample without any functions operating on our data? Some of our values are discrete (ex. a state of 0.5 does us no good). Basically, if we have data that looks like: > SELECT pvName,value FROM "30_days"."BPM" WHERE pvName = 'BR1:BPM2:SA:X' GROUP BY pvName LIMIT 10 name: BPM tags: pvName=BR1:BPM2:SA:X time pvName value ---- ------ ----- 2016-09-12T17:58:22.573523283Z BR1:BPM2:SA:X 1411764 2016-09-12T17:58:22.673306941Z BR1:BPM2:SA:X 858536 2016-09-12T17:58:22.773090839Z BR1:BPM2:SA:X 1170731 2016-09-12T17:58:22.872874736Z BR1:BPM2:SA:X 1326829 2016-09-12T17:58:22.972658634Z BR1:BPM2:SA:X 1182265 2016-09-12T17:58:23.072436571Z BR1:BPM2:SA:X 1170731 2016-09-12T17:58:23.172220468Z BR1:BPM2:SA:X 866995 2016-09-12T17:58:23.272004365Z BR1:BPM2:SA:X 1120000 2016-09-12T17:58:23.371788024Z BR1:BPM2:SA:X 1279999 2016-09-12T17:58:23.471571922Z BR1:BPM2:SA:X 1497536 Is there a way to subsample into a CQ with something like: > CREATE CONTINUOUS QUERY "cq_10s" ON "BPM" BEGIN SELECT pvName,value INTO "1_year"."BPM" WHERE pvName = /.*/ FROM "30_days"."BPM" GROUP BY time(10s,5ms) END I may have messed up the wildcard there, too. Is this sort of thing possible with InfluxQL? Thanks, -Will -- Remember to include the InfluxDB version number with all issue reports --- You received this message because you are subscribed to the Google Groups "InfluxDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/ce1ffc35-54f5-444e-b9d5-451fcef7ddf6%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
