Documentation

Flux syntax basics

This page documents an earlier version of InfluxDB OSS. InfluxDB OSS v2 is the latest stable version. See the equivalent InfluxDB v2 documentation.

Flux, at its core, is a scripting language designed specifically for working with data. This guide walks through a handful of simple expressions and how they are handled in Flux.

Use the influx CLI

Use the influx CLI in “Flux mode” as you follow this guide. When started with -type=flux and -path-prefix=/api/v2/query, the influx CLI is an interactive read-eval-print-loop (REPL) that supports Flux syntax.

Start in the influx CLI in Flux mode
influx -type=flux -path-prefix=/api/v2/query

If using the InfluxData Sandbox, use the ./sandbox enter command to enter the influxdb container, where you can start the influx CLI in Flux mode. You will also need to specify the host as influxdb to connect to InfluxDB over the Docker network.

./sandbox enter influxdb

root@9bfc3c08579c:/# influx -host influxdb -type=flux -path-prefix=/api/v2/query

Basic Flux syntax

The code blocks below provide commands that illustrate the basic syntax of Flux. Run these commands in the influx CLI’s Flux REPL.

Simple expressions

Flux is a scripting language that supports basic expressions. For example, simple addition:

> 1 + 1
2

Variables

Assign an expression to a variable using the assignment operator, =.

> s = "this is a string"
> i = 1 // an integer
> f = 2.0 // a floating point number

Type the name of a variable to print its value:

> s
this is a string
> i
1
> f
2

Records

Flux also supports records. Each value in a record can be a different data type.

> o = {name:"Jim", age: 42, "favorite color": "red"}

Use dot notation to access a properties of a record:

> o.name
Jim
> o.age
42

Or bracket notation:

> o["name"]
Jim
> o["age"]
42
> o["favorite color"]
red

Use bracket notation to reference record properties with special or white space characters in the property key.

Lists

Flux supports lists. List values must be the same type.

> n = 4
> l = [1,2,3,n]
> l
[1, 2, 3, 4]

Functions

Flux uses functions for most of its heavy lifting. Below is a simple function that squares a number, n.

> square = (n) => n * n
> square(n:3)
9

Flux does not support positional arguments or parameters. Parameters must always be named when calling a function.

Pipe-forward operator

Flux uses the pipe-forward operator (|>) extensively to chain operations together. After each function or operation, Flux returns a table or collection of tables containing data. The pipe-forward operator pipes those tables into the next function where they are further processed or manipulated.

data |> someFunction() |> anotherFunction()

Real-world application of basic syntax

This likely seems familiar if you’ve already been through through the other getting started guides. Flux’s syntax is inspired by JavaScript and other functional scripting languages. As you begin to apply these basic principles in real-world use cases such as creating data stream variables, custom functions, etc., the power of Flux and its ability to query and process data will become apparent.

The examples below provide both multi-line and single-line versions of each input command. Carriage returns in Flux aren’t necessary, but do help with readability. Both single- and multi-line commands can be copied and pasted into the influx CLI running in Flux mode.

Define data stream variables

A common use case for variable assignments in Flux is creating variables for one or more input data streams.

timeRange = -1h

cpuUsageUser =
  from(bucket:"telegraf/autogen")
    |> range(start: timeRange)
    |> filter(fn: (r) =>
      r._measurement == "cpu" and
      r._field == "usage_user" and
      r.cpu == "cpu-total"
    )

memUsagePercent =
  from(bucket:"telegraf/autogen")
    |> range(start: timeRange)
    |> filter(fn: (r) =>
      r._measurement == "mem" and
      r._field == "used_percent"
    )

These variables can be used in other functions, such as join(), while keeping the syntax minimal and flexible.

Define custom functions

Create a function that returns the N number rows in the input stream with the highest _values. To do this, pass the input stream (tables) and the number of results to return (n) into a custom function. Then using Flux’s sort() and limit() functions to find the top n results in the data set.

topN = (tables=<-, n) =>
  tables
    |> sort(desc: true)
    |> limit(n: n)

More information about creating custom functions is available in the Custom functions documentation.

Using this new custom function topN and the cpuUsageUser data stream variable defined above, find the top five data points and yield the results.

cpuUsageUser
  |> topN(n:5)
  |> yield()

Define data stream variables

A common use case for variable assignments in Flux is creating variables for multiple filtered input data streams.

timeRange = -1h
cpuUsageUser = from(bucket:"telegraf/autogen") |> range(start: timeRange) |> filter(fn: (r) => r._measurement == "cpu" and r._field == "usage_user" and r.cpu == "cpu-total")
memUsagePercent = from(bucket:"telegraf/autogen") |> range(start: timeRange) |> filter(fn: (r) => r._measurement == "mem" and r._field == "used_percent")

These variables can be used in other functions, such as join(), while keeping the syntax minimal and flexible.

Define custom functions

Let’s create a function that returns the N number rows in the input data stream with the highest _values. To do this, pass the input stream (tables) and the number of results to return (n) into a custom function. Then using Flux’s sort() and limit() functions to find the top n results in the data set.

topN = (tables=<-, n) => tables |> sort(desc: true) |> limit(n: n)

More information about creating custom functions is available in the Custom functions documentation.

Using the cpuUsageUser data stream variable defined above, find the top five data points with the custom topN function and yield the results.

cpuUsageUser |> topN(n:5) |> yield()

This query will return the five data points with the highest user CPU usage over the last hour.


Was this page helpful?

Thank you for your feedback!


The future of Flux

Flux is going into maintenance mode. You can continue using it as you currently are without any changes to your code.

Read more

InfluxDB v3 enhancements and InfluxDB Clustered is now generally available

New capabilities, including faster query performance and management tooling advance the InfluxDB v3 product line. InfluxDB Clustered is now generally available.

InfluxDB v3 performance and features

The InfluxDB v3 product line has seen significant enhancements in query performance and has made new management tooling available. These enhancements include an operational dashboard to monitor the health of your InfluxDB cluster, single sign-on (SSO) support in InfluxDB Cloud Dedicated, and new management APIs for tokens and databases.

Learn about the new v3 enhancements


InfluxDB Clustered general availability

InfluxDB Clustered is now generally available and gives you the power of InfluxDB v3 in your self-managed stack.

Talk to us about InfluxDB Clustered