Documentation

tickscript.select() function

The tickscript.select() function is a user-contributed function maintained by the package author and can be updated or removed at any time.

The tickscript.select() function changes a column’s name and optionally applies an aggregate or selector function to values in the column.

import "contrib/bonitoo-io/tickscript"

tickscript.select(
    column: "_value",
    fn: sum,
    as: "example-name",
)

TICKscript helper function

tickscript.select() is a helper function meant to replicate TICKscript operations like the following:

// Rename
query("SELECT x AS y")

// Aggregate and rename
query("SELECT f(x) AS y")

Parameters

column

Column to operate on. Default is _value.

fn

Aggregate or selector function to apply.

as

(Required) New column name.

tables

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

Examples


Change the name of the value column

import "contrib/bonitoo-io/tickscript"

data
    |> tickscript.select(as: "example-name")
Input data
_time _value
2021-01-01T00:00:00Z 1.2
2021-01-01T01:00:00Z 3.2
2021-01-01T02:00:00Z 4.0
Output data
_time example-name
2021-01-01T00:00:00Z 1.2
2021-01-01T01:00:00Z 3.2
2021-01-01T02:00:00Z 4.0

Change the name of the value column and apply an aggregate function

import "contrib/bonitoo-io/tickscript"

data
    |> tickscript.select(as: "sum", fn: sum)
Input data
_time _value
2021-01-01T00:00:00Z 1.2
2021-01-01T01:00:00Z 3.2
2021-01-01T02:00:00Z 4.0
Output data
sum
8.4

Change the name of the value column and apply a selector function

import "contrib/bonitoo-io/tickscript"

data
    |> tickscript.select(as: "max", fn: max)
Input data
_time _value
2021-01-01T00:00:00Z 1.2
2021-01-01T01:00:00Z 3.2
2021-01-01T02:00:00Z 4.0
Output data
_time max
2021-01-01T02:00:00Z 4.0

Package author and maintainer

Github: @bonitoo-io, @alespour
InfluxDB Slack: @Ales Pour


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.