Spark Functions

Here is a list of all scalar and aggregate Spark functions available in Velox. Function names link to function descriptions. Check out coverage maps for all functions.

Scalar Functions

Aggregate Functions

Window Functions

abs()

floor()

power()

bit_xor()

nth_value()

acos()

get_json_object()

rand()

first()

acosh()

greaterthan()

regexp_extract()

first_ignore_null()

add()

greaterthanorequal()

remainder()

last()

aggregate()

greatest()

replace()

last_ignore_null()

array()

hash()

rlike()

array_contains()

hypot()

round()

array_intersect()

in()

rtrim()

array_sort()

instr()

sec()

ascii()

isnotnull()

sha1()

asinh()

isnull()

sha2()

atanh()

least()

shiftleft()

between()

left()

shiftright()

bin()

length()

sinh()

bitwise_and()

lessthan()

size()

bitwise_or()

lessthanorequal()

sort_array()

ceil()

log1p()

split()

chr()

lower()

startswith()

concat()

ltrim()

substring()

contains()

map()

subtract()

csc()

map_filter()

to_unix_timestamp()

divide()

map_from_arrays()

transform()

element_at()

md5()

trim()

endswith()

might_contain()

unaryminus()

equalnullsafe()

multiply()

unix_timestamp()

equalto()

not()

upper()

exp()

notequalto()

xxhash64()

filter()

pmod()

year()