Related to "Query"
Query data in InfluxDB Clustered
Learn to query data stored in InfluxDB using SQL and InfluxQL.
Execute queries
Use tools and libraries to query data stored in an InfluxDB cluster.
Query data with SQL
Learn to query data stored in InfluxDB Clustered using SQL.
Query data with InfluxQL
Learn to use InfluxQL to query data stored in InfluxDB Clustered.
Explore your schema with InfluxQL
Use InfluxQL SHOW
statements to return information about your data schema.
Explore your schema with SQL
When working with InfluxDB’s implementation of SQL, a measurement is structured as a table, and time, fields, and tags are structured as columns.
Optimize queries
Optimize queries to improve performance and reduce their memory and compute (CPU) requirements in InfluxDB. Learn how to use observability tools to analyze query execution and view metrics.
Query plans
A query plan is a sequence of steps that the InfluxDB Querier devises and executes to calculate the result of a query in the least amount of time. InfluxDB query plans include DataFusion and InfluxDB logical plan and execution plan nodes for scanning, deduplicating, filtering, merging, and sorting data.
Troubleshoot and optimize queries
Troubleshoot errors and optimize performance for SQL and InfluxQL queries in InfluxDB. Use observability tools to view query execution and metrics.
Troubleshoot queries
Troubleshoot SQL and InfluxQL queries in InfluxDB.
Use Grafana to query and visualize data
Install and run Grafana to query and visualize data stored in InfluxDB.
Use Superset to query and visualize data
Install and run Apache Superset to query and visualize data stored in InfluxDB.
Use Tableau to query and visualize data
Install and use Tableau to query and visualize data stored in InfluxDB.
Perform a basic InfluxQL query
A basic InfluxQL query that queries data from InfluxDB most commonly includes SELECT
, FROM
, and WHERE
clauses.
Perform a basic SQL query
A basic SQL query that queries data from InfluxDB most commonly includes SELECT
, FROM
, and WHERE
clauses.
Aggregate data with InfluxQL
Use InfluxQL aggregate and selector functions to perform aggregate operations on your time series data.
Aggregate data with SQL
Use aggregate and selector functions to perform aggregate operations on your time series data.
Cast values to different types
Use the CAST
function or double-colon ::
casting shorthand syntax to cast a value to a specific type.
Use the influxctl CLI to query data
Use the influxctl query
command to query data in InfluxDB Clustered with SQL.
Use the InfluxDB v1 HTTP query API and InfluxQL to query data
Use the InfluxDB v1 HTTP query API to query data in InfluxDB Clustered with InfluxQL.
Use visualization tools to query data
Use visualization tools and SQL or InfluxQL to query data stored in InfluxDB.
Analyze a query plan
Learn how to read and analyze a query plan to understand how a query is executed and find performance bottlenecks.
Understand and troubleshoot Flight responses
Understand responses and troubleshoot errors encountered when querying InfluxDB with Flight+gRPC and Arrow Flight clients.
Use Go to query data
Use the influxdb3-go
Go package and SQL or InfluxQL to query data stored in InfluxDB. Execute queries and retrieve data over the Flight+gRPC protocol, and then process data using common Go tools.
Use Python to query data
Use the influxdb_client_3
Python module and SQL or InfluxQL to query data stored in InfluxDB. Execute queries and retrieve data over the Flight+gRPC protocol, and then process data using common Python tools.
Use parameterized queries with InfluxQL
Use parameterized queries to prevent injection attacks and make queries more reusable.
Use parameterized queries with SQL
Use parameterized queries to prevent injection attacks and make queries more reusable.