Skip to main content
Version: Nightly

Expressions

Aggregate functions​

Flow supports aggregate functions that are supported by the SQL query engine and the Flow plan, such as COUNT, SUM, MIN, and MAX. Unsupported query plans fail when the Flow is created. For a detailed list, please refer to Aggregate Functions.

Scalar functions​

Flow supports scalar functions that are supported by the SQL query engine and the Flow plan. Unsupported query plans fail when the Flow is created. See our SQL reference for the function catalogue.

Here are some commonly used scalar functions in Flow:

  • date_bin: calculates 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 to the specified decimal places.