Query data with InfluxQL

SHOW MEASUREMENTS

SHOW FIELD KEYS FROM "measurement"

SHOW TAG KEYS FROM "measurement"

SHOW TAG VALUES FROM "measurement" WITH KEY = "tag-key" WHERE time > now() - 1d

SELECT temp, room FROM home WHERE time >= now() - 1d

SELECT
  MEAN(temp) AS mean,
  FIRST(hum) as first,
FROM home
GROUP BY tag

SELECT
  MEAN(temp),
  sum(hum),
FROM home
WHERE time >= now() - 24h
GROUP BY time(1h),room

// Use the $parameter syntax to reference parameters in a query.
// The following InfluxQL query contains $room and $min_time parameters.
query := `
    SELECT * FROM home
    WHERE time >= $min_time
      AND temp >= $min_temp
      AND room = $room`

// Assign parameter names to input values.
parameters := influxdb3.QueryParameters{
        "room": "Kitchen",
        "min_temp": 20.0,
        "min_time": "2024-03-18 00:00:00.00",
}

// Call the client's function to query InfluxDB with parameters and the
// the InfluxQL QueryType.
iterator, err := client.QueryWithParameters(context.Background(),
  query,
  parameters,
  influxdb3.WithQueryType(influxdb3.InfluxQL))