Documentation

distinct() function

distinct() returns all unique values in a specified column.

The _value of each output record is set to a distinct value in the specified column. null is considered its own distinct value if present.

Function type signature
(<-tables: stream[A], ?column: string) => stream[B] where A: Record, B: Record
For more information, see Function type signatures.

Parameters

column

Column to return unique values from. Default is _value.

tables

Input data. Default is piped-forward data (<-).

Examples

Return distinct values from the _value column

import "sampledata"

sampledata.int()
    |> distinct()

View example input and ouput

Return distinct values from a non-default column

import "sampledata"

sampledata.int()
    |> distinct(column: "tag")

View example input and ouput

Return distinct values from data with null values

import "sampledata"

sampledata.int(includeNull: true)
    |> distinct()

View example input and ouput


Was this page helpful?

Thank you for your feedback!


Upgrade to InfluxDB Cloud or InfluxDB 2.0!

InfluxDB Cloud and InfluxDB OSS 2.0 ready for production.