Documentation

unique() function

The unique() function returns all records containing unique values in a specified column. Group keys, record columns, and values are not modified.

Function type: Selector
Output data type: Record

unique(column: "_value")

Empty tables

unique() drops empty tables.

Parameters

column

The column searched for unique values. Defaults to "_value".

Data type: String

Examples

from("example-bucket")
 |> range(start: -15m)
 |> filter(fn: (r) => r._measurement == "syslog")
 |> unique(column: "message")

New! Cloud or OSS?

InfluxDB OSS 2.0 now generally available!

InfluxDB OSS 2.0 is now generally available and ready for production use. See the InfluxDB OSS 2.0 release notes.

For information about upgrading to InfluxDB OSS 2.0, see: