Index

A

abs() built-in function, [1], [2] acos() built-in function, [1] acosh() built-in function add() built-in function, [1] add_months() built-in function aggregate() built-in function all_keys_match() built-in function any_keys_match() built-in function any_value() built-in function any_values_match() built-in function approx_distinct() built-in function approx_most_frequent() built-in function approx_percentile() built-in function approx_set() built-in function arbitrary() built-in function array() built-in function array_agg() built-in function array_average() built-in function array_contains() built-in function array_cum_sum() built-in function array_distinct() built-in function, [1] array_duplicates() built-in function array_except() built-in function, [1] array_frequency() built-in function

array_has_duplicates() built-in function array_insert() built-in function array_intersect() built-in function, [1] array_join() built-in function array_max() built-in function, [1] array_min() built-in function, [1] array_normalize() built-in function array_position() built-in function, [1] array_remove() built-in function, [1] array_repeat() built-in function array_sort() built-in function, [1] array_sort_desc() built-in function array_sum() built-in function arrays_overlap() built-in function arrays_union() built-in function ascii() built-in function asin() built-in function, [1] asinh() built-in function at_least_n_non_nulls() built-in function atan() built-in function, [1] atan2() built-in function, [1] atanh() built-in function avg() built-in function, [1]

B

beta_cdf() built-in function between() built-in function, [1] bin() built-in function binomial_cdf() built-in function bit_count() built-in function, [1] bit_get() built-in function bit_length() built-in function bit_xor() built-in function bitwise_and() built-in function, [1] bitwise_and_agg() built-in function bitwise_arithmetic_shift_right() built-in function bitwise_left_shift() built-in function bitwise_logical_shift_right() built-in function bitwise_not() built-in function, [1] bitwise_or() built-in function, [1] bitwise_or_agg() built-in function bitwise_right_shift() built-in function bitwise_right_shift_arithmetic() built-in function bitwise_shift_left() built-in function bitwise_xor() built-in function, [1] bitwise_xor_agg() built-in function bloom_filter_agg() built-in function, [1], [2] bool_and() built-in function bool_or() built-in function built-in function abs(), [1], [2] acos(), [1] acosh() add(), [1] add_months() aggregate() all_keys_match() any_keys_match() any_value() any_values_match() approx_distinct() approx_most_frequent() approx_percentile() approx_set() arbitrary() array() array_agg() array_average() array_contains() array_cum_sum() array_distinct(), [1] array_duplicates() array_except(), [1] array_frequency() array_has_duplicates() array_insert() array_intersect(), [1] array_join() array_max(), [1] array_min(), [1] array_normalize() array_position(), [1] array_remove(), [1] array_repeat() array_sort(), [1] array_sort_desc() array_sum() arrays_overlap() arrays_union() ascii() asin(), [1] asinh() at_least_n_non_nulls() atan(), [1] atan2(), [1] atanh() avg(), [1] beta_cdf() between(), [1] bin() binomial_cdf() bit_count(), [1] bit_get() bit_length() bit_xor() bitwise_and(), [1] bitwise_and_agg() bitwise_arithmetic_shift_right() bitwise_left_shift() bitwise_logical_shift_right() bitwise_not(), [1] bitwise_or(), [1] bitwise_or_agg() bitwise_right_shift() bitwise_right_shift_arithmetic() bitwise_shift_left() bitwise_xor(), [1] bitwise_xor_agg() bloom_filter_agg(), [1], [2] bool_and() bool_or() cardinality() cast() cauchy_cdf() cbrt() ceil(), [1] ceiling() checked_add() checked_divide() checked_multiply() checked_subtract() checksum() chi_squared_cdf() chr(), [1] clamp() classification_fall_out(), [1] classification_miss_rate(), [1] classification_precision(), [1] classification_recall(), [1] classification_thresholds() codepoint() collect_list() collect_set() combinations() concat(), [1], [2] concat_ws() contains(), [1] conv() corr() cos(), [1] cosh(), [1] cosine_similarity() cot() count() count_if() covar_pop() covar_samp() crc32(), [1] csc() cume_dist() current_date() date() date_add(), [1] date_diff() date_format() date_from_unix_date() date_sub() date_trunc() datediff() day() day_of_month() day_of_week() day_of_year() dayofmonth() dayofweek() dayofyear() decimal_equalto() decimal_greaterthan() decimal_greaterthanorequal() decimal_lessthan() decimal_lessthanorequal() decimal_notequalto() decimal_round() degrees(), [1] dense_rank(), [1] distinct_from() divide(), [1], [2], [3], [4] dow() doy() e() element_at(), [1] empty2null() empty_approx_set() ends_with() endswith() entropy() eq() equalnullsafe() equalto() every() exp(), [1] expm1() f_cdf() fail(), [1], [2], [3] filter(), [1] find_first() find_first_index() find_in_set() first() first_ignore_null() first_value() flatten(), [1] floor(), [1], [2] format_datetime() from_base() from_base64() from_base64url() from_big_endian_32() from_big_endian_64() from_hex() from_ieee754_32() from_ieee754_64() from_iso8601_date() from_iso8601_timestamp() from_unixtime(), [1], [2] from_utc_timestamp() from_utf8() gamma_cdf() geometric_mean() get() get_json_object() get_timestamp() greaterthan() greaterthanorequal() greatest(), [1] gt() gte() hamming_distance() hash() hash_with_seed() hex() histogram() hmac_md5() hmac_sha1() hmac_sha256() hmac_sha512() hour(), [1] hypot() in() infinity() instr() inverse_beta_cdf() inverse_cauchy_cdf() inverse_laplace_cdf() inverse_normal_cdf() inverse_weibull_cdf() ip_prefix() is_finite() is_infinite() is_json_scalar() is_nan() is_null() isnan() isnotnull() isnull() json_array_contains() json_array_get() json_array_length() json_extract() json_extract_scalar() json_format() json_object_keys() json_parse() json_size() kurtosis(), [1] lag() laplace_cdf() last() last_day() last_day_of_month() last_ignore_null() last_value() lead() least(), [1] left() length(), [1], [2] lessthan() lessthanorequal() levenshtein() levenshtein_distance() like(), [1] ln() locate() log() log10(), [1] log1p() log2(), [1] lower(), [1] lpad(), [1] lt() lte() ltrim(), [1] make_date() make_decimal() make_timestamp() make_ym_interval() map(), [1] map_agg() map_concat() map_entries(), [1] map_filter(), [1] map_from_arrays() map_from_entries() map_keys(), [1] map_normalize() map_remove_null_values() map_subset() map_top_n() map_top_n_keys() map_union() map_union_sum() map_values(), [1] map_zip_with(), [1] mask() max(), [1] max_by(), [1] max_data_size_for_stats() md5(), [1] merge() might_contain() millisecond() min(), [1] min_by(), [1] minus(), [1], [2] minute(), [1] mod() mode() modulus() monotonically_increasing_id() month(), [1] multimap_agg() multimap_from_entries() multiply(), [1], [2], [3], [4], [5] nan() negate(), [1] neq() next_day() ngrams() no_keys_match() no_values_match() normal_cdf() normalize(), [1] not() notequalto() nth_value() ntile(), [1] overlay() parse_datetime() percent_rank() pi() plus(), [1], [2] pmod() poisson_cdf() pow() power(), [1] quarter(), [1] radians() raise_error() rand(), [1], [2] random(), [1], [2] rank(), [1] reduce() reduce_agg() regexp_extract(), [1] regexp_extract_all(), [1] regexp_like() regexp_replace(), [1], [2] regexp_split() regr_avgx() regr_avgy() regr_count() regr_intercept() regr_r2() regr_replacement() regr_slope() regr_sxx() regr_sxy() regr_syy() remainder() remove_nulls() repeat(), [1] replace(), [1], [2] replaceFirst() reverse(), [1] rint() rlike() round(), [1], [2], [3] row_number(), [1] rpad(), [1] rtrim(), [1] sec() second(), [1] secure_rand() secure_random(), [1] sequence() set_agg() set_union() sha1(), [1] sha2() sha256() sha512() shiftleft() shiftright() shuffle(), [1] sign() sin() sinh() size() skewness(), [1] slice(), [1] sort_array() soundex() spark_partition_id() split(), [1] split_part() split_to_map(), [1] spooky_hash_v2_32() spooky_hash_v2_64() sqrt() starts_with() startswith() stddev() stddev_pop() stddev_samp() str_to_map() strpos() strrpos() subscript() substr() substring() substring_index() subtract(), [1] sum(), [1] sum_data_size_for_stats() tan() tanh() timestamp_micros() timestamp_millis() timezone_hour() timezone_minute() to_base() to_base64() to_base64url() to_big_endian_32() to_big_endian_64() to_hex() to_ieee754_32() to_ieee754_64() to_iso8601() to_milliseconds() to_unix_timestamp() to_unixtime() to_utc_timestamp() to_utf8() trail() transform(), [1] transform_keys() transform_values() translate() trim(), [1] trim_array() truncate(), [1], [2] try_cast() typeof() unaryminus(), [1] unhex() unix_date() unix_micros() unix_millis() unix_seconds() unix_timestamp() unscaled_value() upper(), [1] url_decode(), [1] url_encode(), [1] url_extract_fragment() url_extract_host() url_extract_parameter() url_extract_path() url_extract_port() url_extract_protocol() url_extract_query() uuid(), [1] var_pop() var_samp() variance() week() week_of_year(), [1] weekday() weibull_cdf() width_bucket(), [1] wilson_interval_lower() wilson_interval_upper() word_stem(), [1] xxhash64(), [1] xxhash64_with_seed() year(), [1] year_of_week(), [1] yow() zip() zip_with(), [1]

C

cardinality() built-in function cast() built-in function cauchy_cdf() built-in function cbrt() built-in function ceil() built-in function, [1] ceiling() built-in function checked_add() built-in function checked_divide() built-in function checked_multiply() built-in function checked_subtract() built-in function checksum() built-in function chi_squared_cdf() built-in function chr() built-in function, [1] clamp() built-in function classification_fall_out() built-in function, [1] classification_miss_rate() built-in function, [1] classification_precision() built-in function, [1] classification_recall() built-in function, [1] classification_thresholds() built-in function codepoint() built-in function

collect_list() built-in function collect_set() built-in function combinations() built-in function concat() built-in function, [1], [2] concat_ws() built-in function contains() built-in function, [1] conv() built-in function corr() built-in function cos() built-in function, [1] cosh() built-in function, [1] cosine_similarity() built-in function cot() built-in function count() built-in function count_if() built-in function covar_pop() built-in function covar_samp() built-in function crc32() built-in function, [1] csc() built-in function cume_dist() built-in function current_date() built-in function

D

date() built-in function date_add() built-in function, [1] date_diff() built-in function date_format() built-in function date_from_unix_date() built-in function date_sub() built-in function date_trunc() built-in function datediff() built-in function day() built-in function day_of_month() built-in function day_of_week() built-in function day_of_year() built-in function dayofmonth() built-in function dayofweek() built-in function

dayofyear() built-in function decimal_equalto() built-in function decimal_greaterthan() built-in function decimal_greaterthanorequal() built-in function decimal_lessthan() built-in function decimal_lessthanorequal() built-in function decimal_notequalto() built-in function decimal_round() built-in function degrees() built-in function, [1] dense_rank() built-in function, [1] distinct_from() built-in function divide() built-in function, [1], [2], [3], [4] dow() built-in function doy() built-in function

E

e() built-in function element_at() built-in function, [1] empty2null() built-in function empty_approx_set() built-in function ends_with() built-in function endswith() built-in function entropy() built-in function

eq() built-in function equalnullsafe() built-in function equalto() built-in function every() built-in function exp() built-in function, [1] expm1() built-in function

F

f_cdf() built-in function fail() built-in function, [1], [2], [3] filter() built-in function, [1] find_first() built-in function find_first_index() built-in function find_in_set() built-in function first() built-in function first_ignore_null() built-in function first_value() built-in function flatten() built-in function, [1] floor() built-in function, [1], [2] format_datetime() built-in function from_base() built-in function

from_base64() built-in function from_base64url() built-in function from_big_endian_32() built-in function from_big_endian_64() built-in function from_hex() built-in function from_ieee754_32() built-in function from_ieee754_64() built-in function from_iso8601_date() built-in function from_iso8601_timestamp() built-in function from_unixtime() built-in function, [1], [2] from_utc_timestamp() built-in function from_utf8() built-in function

G

gamma_cdf() built-in function geometric_mean() built-in function get() built-in function get_json_object() built-in function get_timestamp() built-in function

greaterthan() built-in function greaterthanorequal() built-in function greatest() built-in function, [1] gt() built-in function gte() built-in function

H

hamming_distance() built-in function hash() built-in function hash_with_seed() built-in function hex() built-in function histogram() built-in function hmac_md5() built-in function

hmac_sha1() built-in function hmac_sha256() built-in function hmac_sha512() built-in function hour() built-in function, [1] hypot() built-in function

I

in() built-in function infinity() built-in function instr() built-in function inverse_beta_cdf() built-in function inverse_cauchy_cdf() built-in function inverse_laplace_cdf() built-in function inverse_normal_cdf() built-in function inverse_weibull_cdf() built-in function ip_prefix() built-in function

is_finite() built-in function is_infinite() built-in function is_json_scalar() built-in function is_nan() built-in function is_null() built-in function isnan() built-in function isnotnull() built-in function isnull() built-in function

J

json_array_contains() built-in function json_array_get() built-in function json_array_length() built-in function json_extract() built-in function json_extract_scalar() built-in function

json_format() built-in function json_object_keys() built-in function json_parse() built-in function json_size() built-in function

K

kurtosis() built-in function, [1]

L

lag() built-in function laplace_cdf() built-in function last() built-in function last_day() built-in function last_day_of_month() built-in function last_ignore_null() built-in function last_value() built-in function lead() built-in function least() built-in function, [1] left() built-in function length() built-in function, [1], [2] lessthan() built-in function lessthanorequal() built-in function levenshtein() built-in function

levenshtein_distance() built-in function like() built-in function, [1] ln() built-in function locate() built-in function log() built-in function log10() built-in function, [1] log1p() built-in function log2() built-in function, [1] lower() built-in function, [1] lpad() built-in function, [1] lt() built-in function lte() built-in function ltrim() built-in function, [1]

M

make_date() built-in function make_decimal() built-in function make_timestamp() built-in function make_ym_interval() built-in function map() built-in function, [1] map_agg() built-in function map_concat() built-in function map_entries() built-in function, [1] map_filter() built-in function, [1] map_from_arrays() built-in function map_from_entries() built-in function map_keys() built-in function, [1] map_normalize() built-in function map_remove_null_values() built-in function map_subset() built-in function map_top_n() built-in function map_top_n_keys() built-in function map_union() built-in function map_union_sum() built-in function map_values() built-in function, [1] map_zip_with() built-in function, [1]

mask() built-in function max() built-in function, [1] max_by() built-in function, [1] max_data_size_for_stats() built-in function md5() built-in function, [1] merge() built-in function might_contain() built-in function millisecond() built-in function min() built-in function, [1] min_by() built-in function, [1] minus() built-in function, [1], [2] minute() built-in function, [1] mod() built-in function mode() built-in function modulus() built-in function monotonically_increasing_id() built-in function month() built-in function, [1] multimap_agg() built-in function multimap_from_entries() built-in function multiply() built-in function, [1], [2], [3], [4], [5]

N

nan() built-in function negate() built-in function, [1] neq() built-in function next_day() built-in function ngrams() built-in function no_keys_match() built-in function no_values_match() built-in function

normal_cdf() built-in function normalize() built-in function, [1] not() built-in function notequalto() built-in function nth_value() built-in function ntile() built-in function, [1]

O

overlay() built-in function

P

parse_datetime() built-in function percent_rank() built-in function pi() built-in function plus() built-in function, [1], [2]

pmod() built-in function poisson_cdf() built-in function pow() built-in function power() built-in function, [1]

Q

quarter() built-in function, [1]

R

radians() built-in function raise_error() built-in function rand() built-in function, [1], [2] random() built-in function, [1], [2] rank() built-in function, [1] reduce() built-in function reduce_agg() built-in function regexp_extract() built-in function, [1] regexp_extract_all() built-in function, [1] regexp_like() built-in function regexp_replace() built-in function, [1], [2] regexp_split() built-in function regr_avgx() built-in function regr_avgy() built-in function regr_count() built-in function regr_intercept() built-in function regr_r2() built-in function

regr_replacement() built-in function regr_slope() built-in function regr_sxx() built-in function regr_sxy() built-in function regr_syy() built-in function remainder() built-in function remove_nulls() built-in function repeat() built-in function, [1] replace() built-in function, [1], [2] replaceFirst() built-in function reverse() built-in function, [1] rint() built-in function rlike() built-in function round() built-in function, [1], [2], [3] row_number() built-in function, [1] rpad() built-in function, [1] rtrim() built-in function, [1]

S

sec() built-in function second() built-in function, [1] secure_rand() built-in function secure_random() built-in function, [1] sequence() built-in function set_agg() built-in function set_union() built-in function sha1() built-in function, [1] sha2() built-in function sha256() built-in function sha512() built-in function shiftleft() built-in function shiftright() built-in function shuffle() built-in function, [1] sign() built-in function sin() built-in function sinh() built-in function size() built-in function skewness() built-in function, [1] slice() built-in function, [1] sort_array() built-in function soundex() built-in function

spark_partition_id() built-in function split() built-in function, [1] split_part() built-in function split_to_map() built-in function, [1] spooky_hash_v2_32() built-in function spooky_hash_v2_64() built-in function sqrt() built-in function starts_with() built-in function startswith() built-in function stddev() built-in function stddev_pop() built-in function stddev_samp() built-in function str_to_map() built-in function strpos() built-in function strrpos() built-in function subscript() built-in function substr() built-in function substring() built-in function substring_index() built-in function subtract() built-in function, [1] sum() built-in function, [1] sum_data_size_for_stats() built-in function

T

tan() built-in function tanh() built-in function timestamp_micros() built-in function timestamp_millis() built-in function timezone_hour() built-in function timezone_minute() built-in function to_base() built-in function to_base64() built-in function to_base64url() built-in function to_big_endian_32() built-in function to_big_endian_64() built-in function to_hex() built-in function to_ieee754_32() built-in function to_ieee754_64() built-in function to_iso8601() built-in function

to_milliseconds() built-in function to_unix_timestamp() built-in function to_unixtime() built-in function to_utc_timestamp() built-in function to_utf8() built-in function trail() built-in function transform() built-in function, [1] transform_keys() built-in function transform_values() built-in function translate() built-in function trim() built-in function, [1] trim_array() built-in function truncate() built-in function, [1], [2] try_cast() built-in function typeof() built-in function

U

unaryminus() built-in function, [1] unhex() built-in function unix_date() built-in function unix_micros() built-in function unix_millis() built-in function unix_seconds() built-in function unix_timestamp() built-in function unscaled_value() built-in function upper() built-in function, [1] url_decode() built-in function, [1]

url_encode() built-in function, [1] url_extract_fragment() built-in function url_extract_host() built-in function url_extract_parameter() built-in function url_extract_path() built-in function url_extract_port() built-in function url_extract_protocol() built-in function url_extract_query() built-in function uuid() built-in function, [1]

V

var_pop() built-in function var_samp() built-in function

variance() built-in function

W

week() built-in function week_of_year() built-in function, [1] weekday() built-in function weibull_cdf() built-in function

width_bucket() built-in function, [1] wilson_interval_lower() built-in function wilson_interval_upper() built-in function word_stem() built-in function, [1]

X

xxhash64() built-in function, [1]

xxhash64_with_seed() built-in function

Y

year() built-in function, [1] year_of_week() built-in function, [1]

yow() built-in function

Z

zip() built-in function

zip_with() built-in function, [1]