Query data with InfluxQL

The influx CLI provides an InfluxQL shell where you can execute InfluxQL queries in an interactive Read-Eval-Print-Loop (REPL).

1. If you haven’t already, do the following:

   • Download and install the influx CLI
   • Configure your authentication credentials

2. Use the following command to start an InfluxQL shell:

   influx v1 shell
   

3. Execute an InfluxQL query inside the InfluxQL shell.

   SELECT used_percent FROM "example-db"."example-rp"."example-measurement" WHERE host=host1
   

   For more information, see how to use the InfluxQL shell. For more information about DBRP mappings, see Manage DBRP mappings.

The InfluxDB 1.x compatibility API supports all InfluxDB 1.x client libraries and integrations in InfluxDB 2.7.

1. To query a mapped bucket with InfluxQL, use the /query 1.x compatibility endpoint, and include the following in your request:

   • Request method: GET
   • Headers:
     • Authorization: See compatibility API authentication
   • Query parameters:

     • db: 1.x database to query

     • rp: 1.x retention policy to query (if no retention policy is specified, InfluxDB uses the default retention policy for the specified database)

     • q: URL-encoded InfluxQL query

       URL-encode query parameters that may contain whitespace or other special characters.

   curl --get http://localhost:8086/query?db=example-db \
     --header "Authorization: Token YourAuthToken" \
     --data-urlencode "q=SELECT used_percent FROM \"example-db\".\"example-rp\".\"example-measurement\" WHERE host=host1"
   

   By default, the /query compatibility endpoint returns results in JSON.

2. (Optional) To return results as CSV, include the Accept: application/csv header.

For more information about DBRP mappings, see Manage DBRP mappings.