InfluxDB Aggregation - N1ql Typing CST Test
Loading…
InfluxDB Aggregation — N1ql Code
Querying averages and grouping by time intervals in InfluxDB.
SELECT MEAN(value)
FROM cpu_usage
WHERE time > now() - 1h
GROUP BY time(5m);N1ql Language Guide
N1QL (Non-First Normal Form Query Language) is Couchbase’s SQL-like query language designed for JSON document databases. It enables SQL-style querying, joins, aggregation, indexing, and full-text search on flexible JSON data.
Primary Use Cases
- ▸SQL-style querying on JSON data
- ▸JOIN operations on NoSQL JSON documents
- ▸High-performance analytics
- ▸Full-text search and indexing
- ▸Caching and session management
- ▸Recommendation engines and personalization pipelines
Notable Features
- ▸Full SQL capabilities (SELECT, JOIN, GROUP BY, ORDER BY)
- ▸Powerful secondary indexing
- ▸Supports JSON-based schema flexibility
- ▸User-defined functions and expressions
- ▸Full-text search integration (FTS)
- ▸High-performance distributed execution
Origin & Creator
Developed by Couchbase Inc., introduced publicly in 2015 to provide SQL querying capabilities on JSON in a distributed NoSQL database.
Industrial Note
N1QL excels in environments needing massive read/write throughput with SQL-like querying over JSON-such as ad-tech, gaming, finance, e-commerce personalization, digital catalogs, session stores, caching layers, and multi-model microservices.