Time Series Database:WHERE clauses

Fields

field_key <operator> ['string' | boolean | float | integer]

Field values can be strings, Booleans, floats, or integers.

Supported operators:

Arithmetic operators and regular expressions are also supported.

Tags

tag_key <operator> ['tag_value']

Supported operators:

Regular expressions are also supported.

Timestamps

The default time range depends on the query type:

For the full timestamp syntax, see the Time syntax topic.

Filter by a numeric field value

SELECT * FROM "h2o_feet" WHERE "water_level" > 8

Returns all data points in h2o_feet where water_level exceeds 8:

Filter by a string field value

SELECT * FROM "h2o_feet" WHERE "level description" = 'below 3 feet'

Returns all data points where level description equals below 3 feet. String field values must be in single quotation marks.

Filter using an arithmetic operator

SELECT * FROM "h2o_feet" WHERE "water_level" + 2 > 11.9

Returns data points where adding 2 to water_level exceeds 11.9. Standard arithmetic operator precedence applies. For details, see the InfluxQL arithmetic operators topic.

Filter by a tag value

SELECT "water_level" FROM "h2o_feet" WHERE "location" = 'santa_monica'

Returns all data points where the location tag equals santa_monica. Tag values must be in single quotation marks.

Filter by field and tag values together

SELECT "water_level" FROM "h2o_feet" WHERE "location" <> 'santa_monica' AND ("water_level" < -0.59 OR "water_level" > 9.95)

Returns data points where location is not santa_monica and water_level is below -0.59 or above 9.95. Use parentheses to group OR conditions within an AND expression.

Filter by timestamp

SELECT * FROM "h2o_feet" WHERE time > now() - 7d

Returns data points from h2o_feet with timestamps in the last seven days. For the full timestamp syntax, see the Time syntax topic.

No results returned

If a query returns no results and no error, check that all string field values and tag values are enclosed in single quotation marks (').

Tag values:

SELECT "water_level" FROM "h2o_feet" WHERE "location" = santa_monica
SELECT "water_level" FROM "h2o_feet" WHERE "location" = "santa_monica"
SELECT "water_level" FROM "h2o_feet" WHERE "location" = 'santa_monica'

The first two queries return no data. The third, with single quotation marks, returns the expected results:

String field values:

SELECT "level description" FROM "h2o_feet" WHERE "level description" = at or greater than 9 feet
ERR: error parsing query: found than, expected ; at line 1, char 86
SELECT "level description" FROM "h2o_feet" WHERE "level description" = "at or greater than 9 feet"
SELECT "level description" FROM "h2o_feet" WHERE "level description" = 'at or greater than 9 feet'

Without quotes, a parse error is returned because the value contains spaces. With double quotation marks, the query runs but returns no data. With single quotation marks, the query returns the expected results: