Module datafusion_expr::expr_fn
source · [−]Expand description
Expr fn module contains the functional definitions for expressions.
Functions
Unary scalar function definition for abs
Unary scalar function definition for acos
Return a new expression with a logical AND
Returns the approximate number of distinct input values. This function provides an approximation of count(DISTINCT x). Zero is returned if all input values are null. This function should produce a standard error of 0.81%, which is the standard deviation of the (approximately normal) error distribution over all possible sets. It does not guarantee an upper bound on the error for any specific input set.
Calculate an approximation of the specified percentile for expr.
Returns an array of fixed size with each argument on it.
Scalar function definition for ascii
Unary scalar function definition for asin
Unary scalar function definition for atan
Create an expression to represent the avg() aggregate function
Return a new expression l
Scalar function definition for bit_length
Scalar function definition for btrim
Unary scalar function definition for ceil
Scalar function definition for character_length
Scalar function definition for chr
Create a column expression based on a qualified or unqualified column name
Concatenates the text representations of all the arguments. NULL arguments are ignored.
Concatenates all but the first argument, with separators. The first argument is used as the separator string, and should not be NULL. Other NULL arguments are ignored.
Unary scalar function definition for cos
Create an expression to represent the count() aggregate function
Create an expression to represent the count(distinct) aggregate function
Scalar function definition for date_part
Scalar function definition for date_trunc
Scalar function definition for digest
Unary scalar function definition for exp
Unary scalar function definition for floor
Create an in_list expression
Scalar function definition for initcap
Scalar function definition for left
Scalar function definition for length
Unary scalar function definition for ln
Unary scalar function definition for log2
Unary scalar function definition for log10
Scalar function definition for lower
Scalar function definition for lpad
Scalar function definition for ltrim
Create an expression to represent the max() aggregate function
Scalar function definition for md5
Create an expression to represent the min() aggregate function
Unary scalar function definition for now
Scalar function definition for octet_length
Return a new expression with a logical OR
Returns a random value in the range 0.0 <= x < 1.0
Scalar function definition for regexp_match
Scalar function definition for regexp_replace
Scalar function definition for repeat
Scalar function definition for replace
Scalar function definition for reverse
Scalar function definition for right
Unary scalar function definition for round
Scalar function definition for rpad
Scalar function definition for rtrim
Scalar function definition for sha224
Scalar function definition for sha256
Scalar function definition for sha384
Scalar function definition for sha512
Unary scalar function definition for signum
Unary scalar function definition for sin
Scalar function definition for split_part
Unary scalar function definition for sqrt
Scalar function definition for starts_with
Scalar function definition for strpos
Scalar function definition for substr
Create an expression to represent the sum() aggregate function
Unary scalar function definition for tan
Scalar function definition for to_hex
Scalar function definition for translate
Scalar function definition for trim
Unary scalar function definition for trunc
Scalar function definition for upper