tickscript.select() function
tickscript.select() is a user-contributed function maintained by
the package author.
tickscript.select() changes a column’s name and optionally applies an aggregate or selector
function to values in the column.
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")
Function type signature
(<-tables: B, as: string, ?column: A, ?fn: (<-: B, column: A) => stream[C]) => stream[D] where A: Equatable, C: Record, D: Record
For more information, see Function type signatures.
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
- Change the name of the value column and apply an aggregate function
- Change the name of the value column and apply a selector function
Change the name of the value column
import "contrib/bonitoo-io/tickscript"
import "sampledata"
sampledata.int()
|> tickscript.select(as: "example-name")
Change the name of the value column and apply an aggregate function
import "contrib/bonitoo-io/tickscript"
import "sampledata"
sampledata.int()
|> tickscript.select(as: "sum", fn: sum)
Change the name of the value column and apply a selector function
import "contrib/bonitoo-io/tickscript"
import "sampledata"
sampledata.int()
|> tickscript.select(as: "max", fn: max)
Was this page helpful?
Thank you for your feedback!
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for Flux and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support. Customers using a trial license can email trial@influxdata.com for assistance.