influxdb3 query
InfluxDB 3 Enterprise is in Public Alpha
InfluxDB 3 Enterprise is in public alpha and available for testing and feedback, but is not meant for production use. Both the product and this documentation are works in progress. We welcome and encourage your input about your experience with the alpha and invite you to join our public channels for updates and to share feedback.
The influxdb3 query
command executes a query against a running
InfluxDB 3 Enterprise server.
Usage
influxdb3 query [OPTIONS] --database <DATABASE_NAME> [QUERY]...
Aliases
query
, q
Arguments
QUERY: The query to execute. Provide the query in one of the following ways:
- a string
- a path to a file that contains the query using the
--file
option - from stdin
Options
Option | Description | |
---|---|---|
-H | --host | Host URL of the running InfluxDB 3 Enterprise server (default is http://127.0.0.1:8181 ) |
-d | --database | (Required) Name of the database to operate on |
--token | Authentication token | |
-l | --language | Query language of the query string (sql (default) or influxql ) |
--format | Output format (pretty (default), json , jsonl , csv , parquet ) | |
-o | --output | Output query results to the specified file |
-f | --file | A file that contains the query to execute |
-h | --help | Print help information |
Option environment variables
You can use the following environment variables to set command options:
Environment Variable | Option |
---|---|
INFLUXDB3_HOST_URL | --host |
INFLUXDB3_DATABASE_NAME | --database |
INFLUXDB3_AUTH_TOKEN | --token |
Examples
- Query data using SQL
- Query data using InfluxQL
- Query data and return JSON-formatted results
- Query data and write results to a file
In the examples below, replace
DATABASE_NAME
:
with the name of the database to query.
Query data using SQL
influxdb3 query --database DATABASE_NAME 'SELECT * FROM home'
influxdb3 query --database DATABASE_NAME --file ./query.sql
cat ./query.sql | influxdb3 query --database DATABASE_NAME
Query data using InfluxQL
influxdb3 query \
--language influxql \
--database DATABASE_NAME \
'SELECT * FROM home'
influxdb3 query \
--language influxql \
--database DATABASE_NAME \
--file ./query.influxql
cat ./query.influxql | influxdb3 query \
--language influxql \
--database DATABASE_NAME
Query data and return JSON-formatted results
influxdb3 query \
--format json \
--database DATABASE_NAME \
'SELECT * FROM home'
influxdb3 query \
--format json \
--database DATABASE_NAME \
--file ./query.sql
cat ./query.sql | influxdb3 query \
--format json \
--database DATABASE_NAME
Query data and write results to a file
influxdb3 query \
--output /path/to/results.txt \
--database DATABASE_NAME \
'SELECT * FROM home'
influxdb3 query \
--output /path/to/results.txt \
--database DATABASE_NAME \
--file ./query.sql
cat ./query.sql | influxdb3 query \
--output /path/to/results.txt \
--database DATABASE_NAME
Was this page helpful?
Thank you for your feedback!
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for InfluxDB 3 Enterprise and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support.