Skip to main content
Version: Nightly

Expressions

Aggregate functions

Flow support all aggregate functions that a normal sql query supports such as COUNT, SUM, MIN, MAX, etc. For a detailed list, please refer to Aggregate Functions.

Scalar functions

Flow support all scalar functions that a normal sql query supports in our SQL reference.

And here are some of the most commonly used scalar functions in flow:

  • date_bin: calculate time intervals and returns the start of the interval nearest to the specified timestamp.
  • date_trunc: truncate a timestamp value to a specified precision.
  • trunc: truncate a number to a whole number or truncated to the specified decimal places.