Module datafusion_expr::expr_fn

Functions for creating logical expressions

Functions

abs

Unary scalar function definition for abs

acos

Unary scalar function definition for acos

and

Return a new expression with a logical AND

approx_distinct

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.

approx_percentile_cont

Calculate an approximation of the specified percentile for expr.

approx_percentile_cont_with_weight

Calculate an approximation of the specified percentile for expr and weight_expr.

array

Returns an array of fixed size with each argument on it.

ascii

Scalar function definition for ascii

asin

Unary scalar function definition for asin

atan

Unary scalar function definition for atan

avg

Create an expression to represent the avg() aggregate function

binary_expr

Return a new expression l r

bit_length

Scalar function definition for bit_length

btrim

Scalar function definition for btrim

call_fn

Calls a named built in function

case

Create a CASE WHEN statement with literal WHEN expressions for comparison to the base expression.

ceil

Unary scalar function definition for ceil

character_length

Scalar function definition for character_length

chr

Scalar function definition for chr

coalesce

Returns coalesce(args...), which evaluates to the value of the first Expr which is not NULL

col

Create a column expression based on a qualified or unqualified column name

combine_filters

Combines an array of filter expressions into a single filter expression consisting of the input filter expressions joined with logical AND. Returns None if the filters array is empty.

concat

Concatenates the text representations of all the arguments. NULL arguments are ignored.

concat_expr

Scalar function definition for concat_expr

concat_ws

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.

concat_ws_expr

Scalar function definition for concat_ws_expr

cos

Unary scalar function definition for cos

count

Create an expression to represent the count() aggregate function

count_distinct

Create an expression to represent the count(distinct) aggregate function

create_udaf

Creates a new UDAF with a specific signature, state type and return type. The signature and state type must match the Accumulator's implementation.

create_udf

Creates a new UDF with a specific signature and specific return type. This is a helper function to create a new UDF. The function create_udf returns a subset of all possible ScalarFunction:

cube

Create a grouping set for all combination of exprs

date_part

Scalar function definition for date_part

date_trunc

Scalar function definition for date_trunc

digest

Scalar function definition for digest

exists

Create an EXISTS subquery expression

exp

Unary scalar function definition for exp

floor

Unary scalar function definition for floor

grouping_set

Create a grouping set

in_list

Create an in_list expression

in_subquery

Create an IN subquery expression

initcap

Scalar function definition for initcap

left

Scalar function definition for left

length

Scalar function definition for length

ln

Unary scalar function definition for ln

log2

Unary scalar function definition for log2

log10

Unary scalar function definition for log10

lower

Scalar function definition for lower

lpad

Scalar function definition for lpad

ltrim

Scalar function definition for ltrim

max

Create an expression to represent the max() aggregate function

md5

Scalar function definition for md5

min

Create an expression to represent the min() aggregate function

not_exists

Create a NOT EXISTS subquery expression

not_in_subquery

Create a NOT IN subquery expression

now

Unary scalar function definition for now

now_expr

Scalar function definition for now_expr

nullif

Unary scalar function definition for nullif

octet_length

Scalar function definition for octet_length

or

Return a new expression with a logical OR

power

Scalar function definition for power

random

Returns a random value in the range 0.0 <= x < 1.0

regexp_match

Scalar function definition for regexp_match

regexp_replace

Scalar function definition for regexp_replace

repeat

Scalar function definition for repeat

replace

Scalar function definition for replace

reverse

Scalar function definition for reverse

right

Scalar function definition for right

rollup

Create a grouping set for rollup

round

Unary scalar function definition for round

rpad

Scalar function definition for rpad

rtrim

Scalar function definition for rtrim

scalar_subquery

Create a scalar subquery expression

sha224

Scalar function definition for sha224

sha256

Scalar function definition for sha256

sha384

Scalar function definition for sha384

sha512

Scalar function definition for sha512

signum

Unary scalar function definition for signum

sin

Unary scalar function definition for sin

split_part

Scalar function definition for split_part

sqrt

Unary scalar function definition for sqrt

starts_with

Scalar function definition for starts_with

strpos

Scalar function definition for strpos

substr

Scalar function definition for substr

sum

Create an expression to represent the sum() aggregate function

tan

Unary scalar function definition for tan

to_hex

Scalar function definition for to_hex

to_timestamp_micros

Scalar function definition for to_timestamp_micros

to_timestamp_millis

Scalar function definition for to_timestamp_millis

to_timestamp_seconds

Scalar function definition for to_timestamp_seconds

translate

Scalar function definition for translate

trim

Scalar function definition for trim

trunc

Unary scalar function definition for trunc

unalias

Recursively un-alias an expressions

upper

Scalar function definition for upper

when

Create a CASE WHEN statement with boolean WHEN expressions and no base expression.