Module datafusion::functions_aggregate::expr_fn

Fluent-style API for creating Exprs

Functions

• approx_distinct
  approximate number of distinct input values
• approx_median
  Computes the approximate median of a set of numbers
• approx_percentile_cont
  Computes the approximate percentile continuous of a set of numbers
• approx_percentile_cont_with_weight
  Computes the approximate percentile continuous with weight of a set of numbers
• array_agg
  input values, including nulls, concatenated into an array
• avg
  Returns the avg of a group of values.
• bit_and
  Returns the bitwiseBitwiseOperationType::Andof a group of values
• bit_or
  Returns the bitwiseBitwiseOperationType::Orof a group of values
• bit_xor
  Returns the bitwiseBitwiseOperationType::Xorof a group of values
• bool_and
  The values to combine with AND
• bool_or
  The values to combine with OR
• corr
  Correlation between two numeric values.
• count
  Count the number of non-null values in the column
• count_distinct
• covar_pop
  Computes the population covariance.
• covar_samp
  Computes the sample covariance.
• first_value
  Returns the first value in a group of values.
• grouping
  Returns 1 if the data is aggregated across the specified column or 0 for not aggregated in the result set.
• last_value
  Returns the last value in a group of values.
• max
  Returns the maximum of a group of values.
• median
  Computes the median of a set of numbers
• min
  Returns the minimum of a group of values.
• regr_avgx
  Compute a linear regression of type RegrType::AvgX
• regr_avgy
  Compute a linear regression of type RegrType::AvgY
• regr_count
  Compute a linear regression of type RegrType::Count
• regr_intercept
  Compute a linear regression of type RegrType::Intercept
• regr_r2
  Compute a linear regression of type RegrType::R2
• regr_slope
  Compute a linear regression of type RegrType::Slope
• regr_sxx
  Compute a linear regression of type RegrType::SXX
• regr_sxy
  Compute a linear regression of type RegrType::SXY
• regr_syy
  Compute a linear regression of type RegrType::SYY
• stddev
  Compute the standard deviation of a set of numbers
• stddev_pop
  Compute the population standard deviation of a set of numbers
• sum
  Returns the sum of a group of values.
• var_pop
  Computes the population variance.
• var_sample
  Computes the sample variance.