Get started querying data

1. Visit

   cloud2.influxdata.com in a browser to log in and access the InfluxDB UI.

2. In the left navigation bar, click Data Explorer.

3. The InfluxDB Data Explorer provides two options for querying data with Flux:

   • Query Builder (default): Visual query builder that lets you select the time range, measurement, tags, and fields to query.
   • Script Editor: In-browser code editor for composing and running Flux scripts.

   ---

   Query builder

   To build and execute a Flux query with the query builder:

   1. In the FROM column, select the bucket to query. For this tutorial, select the get-started bucket.

   2. In the next filter column, select _measurement from the column dropdown menu, and then select the home measurement.

   3. (Optional) To query a specific field or fields, in the next filter column, select _field from the column dropdown menu, and then select the fields to query. In this tutorial, there are three fields: co, hum, and temp.

   4. (Optional) To query by specific tag values, in the next filter column, select then tag column from the column dropdown menu, and then select the tag values to filter by. In this tutorial, the tag only tag column is room.

   5. (Optional) In the Aggregate Function pane, select an aggregate or selector function to use to downsample the data. The default aggregate function is mean.

   6. In the time range dropdown menu, select Custom Time Range, and select the following dates from the date selectors:

      • Start: 2022-01-01 08:00:00

      • Stop: 2022-01-01 20:00:01

        Note the addition of one second to the stop time. In Flux, stop times are exclusive and will exclude points with that timestamp. By adding one second, the query will include all points to 2022-01-01 20:00:00.

   7. Click Submit to execute the query with the selected filters and operations and display the result.

   ---

   Script editor

   To write and execute a Flux query with the query builder:

   1. In the Data Explorer, click Script Editor.

   2. Write your Flux query in the Script Editor text field.

      Note: You can either hand-write the functions or you can use the function list to the right of the script editor to search for and inject functions.

      1. Use from() and specify the bucket to query with the bucket parameter. For this tutorial, query the get-started bucket.

      2. Use range() to specify the time range to query. The start parameter defines the earliest time to include in results. The stop parameter specifies the latest time (exclusively) to include in results.

         • start: 2022-01-01T08:00:00Z

         • stop: 2022-01-01T20:00:01Z

           Note the addition of one second to the stop time. In Flux, stop times are exclusive and will exclude points with that timestamp. By adding one second, the query will include all points to 2022-01-01 20:00:00.

         If you want to use the start and stop times selected in the time selection dropdown menu, use v.timeRangeStart and v.timeRangeStop as the values for the start and stop parameters.

      3. Use filter() to filter results by the home measurement.

      4. (Optional) Use filter() to filter results by a specific field. In this tutorial, there are three fields: co, hum, and temp.

      5. (Optional) Use filter() to filter results by specific tag values. In this tutorial, there is one tag, room, with two potential values: Living Room or Kitchen.

      from(bucket: "get-started")
          |> range(start: 2022-01-01T08:00:00Z, stop: 2022-01-01T20:00:01Z)
          |> filter(fn: (r) => r._measurement == "home")
          |> filter(fn: (r) => r._field== "co" or r._field == "hum" or r._field == "temp")
      

      • Copy
      • Fill window

   3. Click Submit to execute the query with the selected filters and operations and display the result.

1. If you haven’t already, download, install, and configure the influx CLI.

2. Use the influx query command to query InfluxDB using Flux.

   Provide the following:

   • String-encoded Flux query.
   • Connection and authentication credentials

influx query '
from(bucket: "get-started")
    |> range(start: 2022-01-01T08:00:00Z, stop: 2022-01-01T20:00:01Z)
    |> filter(fn: (r) => r._measurement == "home")
    |> filter(fn: (r) => r._field== "co" or r._field == "hum" or r._field == "temp")
'

To query data from InfluxDB using Flux and the InfluxDB HTTP API, send a request to the InfluxDB API /api/v2/query endpoint using the POST request method.

POST http://localhost:8086/api/v2/query

Include the following with your request:

• Headers:
  • Authorization: Token <INFLUX_TOKEN>
  • Content-Type: application/vnd.flux
  • Accept: application/csv
  • (Optional) Accept-Encoding: gzip
• Query parameters:
  • org: InfluxDB organization name
• Request body: Flux query as plain text

The following example uses cURL and the InfluxDB API to query data with Flux:

curl --request POST \
"$INFLUX_HOST/api/v2/query?org=$INFLUX_ORG&bucket=get-started" \
  --header "Authorization: Token $INFLUX_TOKEN" \
  --header "Content-Type: application/vnd.flux" \
  --header "Accept: application/csv" \
  --data 'from(bucket: "get-started")
    |> range(start: 2022-01-01T08:00:00Z, stop: 2022-01-01T20:00:01Z)
    |> filter(fn: (r) => r._measurement == "home")
    |> filter(fn: (r) => r._field== "co" or r._field == "hum" or r._field == "temp")
  '

1. If you haven’t already, download, install, and configure the influx CLI.

2. Use the influx v1 shell command to start an InfluxQL shell and query InfluxDB using InfluxQL. Provide the following:

   • Connection and authentication credentials

   influx v1 shell
   

   • Copy
   • Fill window

3. Enter an InfluxQL query and press Enter ↵.

   SELECT co,hum,temp,room FROM "get-started".autogen.home WHERE time >= '2022-01-01T08:00:00Z' AND time <= '2022-01-01T20:00:00Z'
   

   • Copy
   • Fill window

To query data from InfluxDB using InfluxQL and the InfluxDB HTTP API, send a request to the InfluxDB API /query 1.X compatibility endpoint using the POST request method.

POST http://localhost:8086/query

Include the following with your request:

• Headers:

  • Authorization: Token <INFLUX_TOKEN>
  • Accept: application/json
  • (Optional) Accept-Encoding: gzip

• Query parameters:

  • db: Database to query.

  • rp: Retention policy to query data from.

  • q: InfluxQL query to execute.

  • epoch: (Optional) Return results with Unix timestamps of a specified precision instead of RFC3339 timestamps. The following precisions are available:

    • ns - nanoseconds
    • u or µ - microseconds
    • ms - milliseconds
    • s - seconds
    • m - minutes
    • h - hours

• Request body: Flux query as plain text

The following example uses cURL and the InfluxDB API to query data with InfluxQL:

curl --get "$INFLUX_HOST/query?org=$INFLUX_ORG&bucket=get-started" \
  --header "Authorization: Token $INFLUX_TOKEN" \
  --data-urlencode "db=get-started" \
  --data-urlencode "rp=autogen" \
  --data-urlencode "q=SELECT co,hum,temp,room FROM home WHERE time >= '2022-01-01T08:00:00Z' AND time <= '2022-01-01T20:00:00Z'"