Back to Influxdb

sample() function

content/flux/v0/stdlib/universe/sample.md

latest2.7 KB
Original Source
<!------------------------------------------------------------------------------ IMPORTANT: This page was generated from comments in the Flux source code. Any edits made directly to this page will be overwritten the next time the documentation is generated. To make updates to this documentation, update the function comments above the function definition in the Flux source code: https://github.com/influxdata/flux/blob/master/stdlib/universe/universe.flux#L2321-L2323 Contributing to Flux: https://github.com/influxdata/flux#contributing Fluxdoc syntax: https://github.com/influxdata/flux/blob/master/docs/fluxdoc.md ------------------------------------------------------------------------------->

sample() selects a subset of the rows from each input table.

Note: sample() drops empty tables.

Function type signature
js
(<-tables: stream[A], n: int, ?column: string, ?pos: int) => stream[A] where A: Record

{{% caption %}} For more information, see Function type signatures. {{% /caption %}}

Parameters

n

({{< req >}}) Sample every Nth element.

pos

Position offset from the start of results where sampling begins. Default is -1 (random offset).

pos must be less than n. If pos is less than 0, a random offset is used.

column

Column to operate on.

tables

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

Examples

Sample every other result

js
import "sampledata"

sampledata.int()
    |> sample(n: 2, pos: 1)

{{< expand-wrapper >}} {{% expand "View example input and output" %}}

Input data

_time_value*tag
2021-01-01T00:00:00Z-2t1
2021-01-01T00:00:10Z10t1
2021-01-01T00:00:20Z7t1
2021-01-01T00:00:30Z17t1
2021-01-01T00:00:40Z15t1
2021-01-01T00:00:50Z4t1
_time_value*tag
2021-01-01T00:00:00Z19t2
2021-01-01T00:00:10Z4t2
2021-01-01T00:00:20Z-3t2
2021-01-01T00:00:30Z19t2
2021-01-01T00:00:40Z13t2
2021-01-01T00:00:50Z1t2

Output data

_time_value*tag
2021-01-01T00:00:10Z10t1
2021-01-01T00:00:30Z17t1
2021-01-01T00:00:50Z4t1
_time_value*tag
2021-01-01T00:00:10Z4t2
2021-01-01T00:00:30Z19t2
2021-01-01T00:00:50Z1t2

{{% /expand %}} {{< /expand-wrapper >}}