Related to "Query"
Query data in InfluxDB
Learn to query data stored in InfluxDB using Flux and tools such as the InfluxDB user interface and the ‘influx’ command line interface.
Get started with Flux and InfluxDB
Get started with Flux, the functional data scripting language, and learn the basics of writing a Flux query that queries InfluxDB.
influx query
The influx query
command executes a literal Flux query provided as a string or a literal Flux query contained in a file.
Query data with Flux
Guides that walk through both common and complex queries and use cases for Flux.
Query data with InfluxQL
Use the InfluxDB 1.x /query
compatibility endpoint to query data in InfluxDB Cloud and InfluxDB OSS 2.4 with InfluxQL.
Execute queries
There are multiple ways to query data from InfluxDB including the InfluxDB UI, CLI, and API.
InfluxDB 1.x compatibility API
The InfluxDB v2 API includes InfluxDB 1.x compatibility endpoints that work with InfluxDB 1.x client libraries and third-party integrations like Grafana and others.
Optimize Flux queries
Optimize your Flux queries to reduce their memory and compute (CPU) requirements.
Query fields and tags
Use filter()
to query data based on fields, tags, or any other column value. filter()
performs operations similar to the SELECT
statement and the WHERE
clause in InfluxQL and other SQL-like query languages.
Query in Data Explorer
Query InfluxDB using the InfluxDB user interface (UI) Data Explorer. Discover how to query data in InfluxDB 2.1 using the InfluxDB UI.
Query InfluxDB with Flux
Learn the basics of using Flux to query data from InfluxDB.
Query with the InfluxDB API
Query InfluxDB with the InfluxDB API. Discover how to query data in InfluxDB 2.1 using the InfluxDB API.
Transform data with Flux
Learn the basics of using Flux to transform data queried from InfluxDB.
Query in the Flux REPL
Query InfluxDB using the Flux REPL. Discover how to query data in InfluxDB 2.5 using the Flux REPL.
Use the influx query command
Query InfluxDB using the influx CLI. Discover how to query data in InfluxDB 2.1 using influx query
.
Calculate the increase
Use increase()
to track increases across multiple columns in a table. This function is especially useful when tracking changes in counter values that wrap over time or periodically reset.
Calculate the moving average
Use movingAverage()
or timedMovingAverage()
to return the moving average of data.
Calculate the rate of change
Use derivative()
to calculate the rate of change between subsequent values or aggregate.rate()
to calculate the average rate of change per window of time. If time between points varies, these functions normalize points to a common time interval making values easily comparable.
Fill null values in data
Use fill()
function to replace null values.
Find median values
Use median()
to return a value representing the 0.5
quantile (50th percentile) or median of input data.
Find percentile and quantile values
Use the quantile()
function to return all values within the q
quantile or percentile of input data.
Query cumulative sum
Use the cumulativeSum()
function to calculate a running total of values.
Query first and last values
Use first()
or last()
to return the first or last point in an input table.
Query SQL data sources
The Flux sql
package provides functions for working with SQL data sources. Use sql.from()
to query SQL databases like PostgreSQL, MySQL, Snowflake, SQLite, Microsoft SQL Server, Amazon Athena, and Google BigQuery.
Query the Flux version
Use runtime.version()
to return the version of Flux installed in InfluxDB.
/query 1.x compatibility API
The /query
1.x compatibility endpoint queries InfluxDB Cloud and InfluxDB OSS 2.x using InfluxQL.
influx repl
The influx repl
command opens an interactive Read-Eval-Print Loop (REPL) from which you can run Flux commands.