Scalar Functions

Aggregate Functions

Window Functions

abs()

count_if

inline

nvl

sqrt

any

cume_dist

:spark:func:`acos

count_min_sketch

inline_outer

nvl2

stack

approx_count_distinct

dense_rank

acosh()

covar_pop

input_file_block_length

octet_length

std

approx_percentile

first_value

add_months

covar_samp

input_file_block_start

or

stddev

array_agg

lag

aggregate()

crc32

input_file_name

overlay

stddev_pop

avg

last_value

and

cume_dist

instr()

parse_url

stddev_samp

bit_and

lead

any

current_catalog

int

percent_rank

str_to_map

bit_or

nth_value()

approx_count_distinct

current_database

isnan

percentile

string

bit_xor()

ntile

approx_percentile

current_date

isnotnull()

percentile_approx

struct

bool_and

percent_rank

array()

current_timestamp

isnull()

pi

substr

bool_or

rank

array_contains()

current_timezone

java_method

pmod()

substring()

collect_list

row_number

array_distinct

current_user

json_array_length

posexplode

substring_index

collect_set

array_except

date

json_object_keys

posexplode_outer

sum

corr

array_intersect()

date_add

json_tuple

position

tan

count

array_join

date_format

kurtosis

positive

tanh

count_if

array_max

date_from_unix_date

lag

pow

timestamp

count_min_sketch

array_min

date_part

last

power()

timestamp_micros

covar_pop

array_position

date_sub

last_day

printf

timestamp_millis

covar_samp

array_remove

date_trunc

last_value

quarter

timestamp_seconds

every

array_repeat

datediff

lcase

radians

tinyint

first()

array_sort()

day

lead

raise_error

to_csv

first_value

array_union

dayofmonth

least()

rand()

to_date

grouping

arrays_overlap

dayofweek

:spark:funce:`left`

randn

to_json

grouping_id

arrays_zip

dayofyear

length()

random

to_timestamp

histogram_numeric

ascii()

decimal

levenshtein

range

to_unix_timestamp()

kurtosis

asin

decode

like

rank

to_utc_timestamp

last()

asinh()

degrees

ln

reflect

transform()

last_value

assert_true

dense_rank

locate

regexp

transform_keys

max

atan

div

log

regexp_extract()

transform_values

max_by

atan2

double

log10

regexp_extract_all

translate

mean

atanh()

e

log1p()

regexp_like

trim()

min

avg

element_at()

log2

regexp_replace

trunc

min_by

base64

elt

lower()

repeat

try_add

percentile

between()

encode

lpad

replace()

try_divide

percentile_approx

bigint

every

ltrim()

reverse

typeof

regr_avgx

bin()

exists

make_date

right

ucase

regr_avgy

binary

exp()

make_dt_interval

rint

unbase64

regr_count

bit_and

explode

make_interval

rlike()

unhex

regr_r2

bit_count

explode_outer

make_timestamp

round()

unix_date

skewness

bit_get

expm1

make_ym_interval

row_number

unix_micros

some

bit_length

extract

map()

rpad

unix_millis

std

bit_or

factorial

map_concat

rtrim()

unix_seconds

stddev

bit_xor

filter()

map_entries

schema_of_csv

unix_timestamp()

stddev_pop

bool_and

find_in_set

map_filter()

schema_of_json

upper()

stddev_samp

bool_or

first

map_from_arrays()

second

uuid

sum

boolean

first_value

map_from_entries

sentences

var_pop

try_avg

bround

flatten

map_keys

sequence

var_samp

try_sum

btrim

float

map_values

session_window

variance

var_pop

cardinality

floor()

map_zip_with

sha

version

var_samp

case

forall

max

sha1()

weekday

variance

cast

format_number

max_by

sha2()

weekofyear

cbrt

format_string

md5()

shiftleft()

when

ceil()

from_csv

mean

shiftright()

width_bucket

ceiling

from_json

min

shiftrightunsigned

window

char

from_unixtime

min_by

shuffle

xpath

char_length

from_utc_timestamp

minute

sign

xpath_boolean

character_length

get_json_object()

mod

signum

xpath_double

chr()

getbit

monotonically_increasing_id

sin

xpath_float

coalesce

greatest()

month

sinh()

xpath_int

collect_list

grouping

months_between

size()

xpath_long

collect_set

grouping_id

named_struct

skewness

xpath_number

concat()

hash()

nanvl

slice

xpath_short

concat_ws

hex

negative

smallint

xpath_string

conv

hour

next_day

some

xxhash64()

corr

hypot()

not()

sort_array()

year()

cos

if

now

soundex

zip_with

cosh

ifnull

nth_value

space

cot

in()

ntile

spark_partition_id

count

initcap

nullif

split()