influxdb 筆記: Continuous Queries - CQs
# 自動執行查詢
CREATE CONTINUOUS QUERY cq_30m ON food_data BEGIN SELECT mean(website) AS mean_website,mean(phone) AS mean_phone INTO food_data."default".downsampled_orders FROM orders GROUP BY time(30m) END
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26250550/viewspace-2129325/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 《Continuous Integration》讀書筆記筆記
- influxdb 筆記: 安裝UX筆記
- influxdb 筆記: API & CRUDUX筆記API
- influxdb 筆記: 使用者管理UX筆記
- influxdb 筆記: 備份/恢復UX筆記
- influxdb 筆記: 寫高可用 RelayUX筆記
- influxdb 筆記: Retention Police - RPsUX筆記
- GCD QueriesGC
- influxdb記憶體佔用剖析UX記憶體
- PG: Utility queries
- CSS media queriesCSS
- influxdbUX
- Oracle Lock Information QueriesOracleORM
- F - Two Sequence Queries
- F. Scalar Queries
- Trees and XOR Queries AgainAI
- InfluxDB中的inmem記憶體索引結構解析UX記憶體索引
- InfluxDB入門UX
- influxdb基本操作UX
- influxdb知識總結(2)--- influxdb 中的重要概念UX
- [LeetCode] 523. Continuous Subarray SumLeetCode
- influxdb使用入門UX
- JMeter+InfluxDB+GrafanaJMeterUXGrafana
- [轉]Hierarchical Queries之LEVEL應用
- [LeetCode] 674. Longest Continuous Increasing SubsequenceLeetCode
- 印象筆記 --- 方法分享筆記筆記
- InfluxDB 管理工具UX
- Influxdb的Meta data分析UX
- Influxdb 介紹與使用UX
- influxdb 原理與應用UX
- influxdb的基本概念UX
- logstash輸出到influxdbUX
- Jmeter+Influxdb+Grafana搭建JMeterUXGrafana
- PostgreSQL DBA(170) - pgAdmin(Queries For Index Maintenance)SQLIndexAINaN
- Testing JPA Queries with Spring Boot and @DataJpaTestSpring Boot
- Queries to view Alert Log content And Alert LocationView
- Monitor All SQL Queries in MySQL (alias mysql profiler)MySql
- InfluxDB從原理到實戰 - 一篇文章搞懂InfluxDB時區UX