Index

A

abs() built-in function acos() built-in function all_match() built-in function any_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_agg() built-in function array_distinct() built-in function array_except() built-in function array_intersect() built-in function

array_join() built-in function array_max() built-in function array_min() built-in function array_position() built-in function array_remove() built-in function array_sort() built-in function array_union() built-in function arrays_overlap() built-in function asin() built-in function at_timezone() built-in function atan() built-in function atan2() built-in function avg() built-in function

B

bar() built-in function beta_cdf() built-in function bing_tile() built-in function bing_tile_at() built-in function bing_tile_coordinates() built-in function bing_tile_polygon() built-in function bing_tile_quadkey() built-in function bing_tile_zoom_level() built-in function bing_tiles_around() built-in function bit_count() built-in function bitwise_and() built-in function bitwise_and_agg() built-in function bitwise_left_shift() built-in function bitwise_not() built-in function bitwise_or() built-in function bitwise_or_agg() built-in function bitwise_right_shift() built-in function bitwise_right_shift_arithmetic() built-in function bitwise_xor() built-in function bool_and() built-in function bool_or() built-in function built-in function abs() acos() all_match() any_match() approx_distinct() approx_most_frequent() approx_percentile() approx_set() arbitrary() array_agg() array_distinct() array_except() array_intersect() array_join() array_max() array_min() array_position() array_remove() array_sort() array_union() arrays_overlap() asin() at_timezone() atan() atan2() avg() bar() beta_cdf() bing_tile() bing_tile_at() bing_tile_coordinates() bing_tile_polygon() bing_tile_quadkey() bing_tile_zoom_level() bing_tiles_around() bit_count() bitwise_and() bitwise_and_agg() bitwise_left_shift() bitwise_not() bitwise_or() bitwise_or_agg() bitwise_right_shift() bitwise_right_shift_arithmetic() bitwise_xor() bool_and() bool_or() cardinality() cast() cbrt() ceil() ceiling() char2hexint() checksum() chr() classify() coalesce() codepoint() color() combinations() concat() concat_ws() contains() contains_sequence() convex_hull_agg() corr() cos() cosh() cosine_similarity() count() count_if() covar_pop() covar_samp() crc32() cume_dist() current_timezone() date() date_add() date_diff() date_format() date_parse() date_trunc() day() day_of_month() day_of_week() day_of_year() degrees() dense_rank() dow() doy() e() element_at() empty_approx_set() every() exp() extract() features() filter() first_value() flatten() floor() format() format_datetime() from_base() from_base64() from_base64url() from_big_endian_32() from_big_endian_64() from_encoded_polyline() from_hex() from_ieee754_32() from_ieee754_64() from_iso8601_date() from_iso8601_timestamp() from_iso8601_timestamp_nanos() from_unixtime() from_unixtime_nanos() from_utf8() geometric_mean() geometry_from_hadoop_shape() geometry_invalid_reason() geometry_to_bing_tiles() geometry_union() geometry_union_agg() great_circle_distance() greatest() hamming_distance() histogram() hmac_md5() hmac_sha1() hmac_sha256() hmac_sha512() hour() human_readable_seconds() if() index() infinity() inverse_beta_cdf() inverse_normal_cdf() is_finite() is_infinite() is_json_scalar() is_nan() json_array_contains() json_array_get() json_array_length() json_extract() json_extract_scalar() json_format() json_parse() json_size() kurtosis() lag() last_day_of_month() last_value() lead() learn_classifier() learn_libsvm_classifier() learn_libsvm_regressor() learn_regressor() least() length() levenshtein_distance() line_interpolate_point() line_interpolate_points() line_locate_point() ln() log() log10() log2() lower() lpad() ltrim() luhn_check() map() map_agg() map_concat() map_entries() map_filter() map_from_entries() map_keys() map_union() map_values() map_zip_with() max() max_by() md5() merge() millisecond() min() min_by() minute() mod() month() multimap_agg() multimap_from_entries() murmur3() nan() ngrams() none_match() normal_cdf() normalize() now() nth_value() ntile() nullif() numeric_histogram() parse_datetime() parse_duration() parse_presto_data_size() percent_rank() pi() position() pow() power() qdigest_agg() quarter() radians() rand() random() rank() reduce() reduce_agg() regexp_count() regexp_extract() regexp_extract_all() regexp_like() regexp_position() regexp_replace() regexp_split() regr_intercept() regr_slope() regress() render() repeat() replace() reverse() rgb() round() row_number() rpad() rtrim() runtime.kill_query() second() sequence() sha1() sha256() sha512() shuffle() sign() simplify_geometry() sin() skewness() slice() split() split_part() split_to_map() split_to_multimap() spooky_hash_v2_32() spooky_hash_v2_64() sqrt() ST_Area() ST_AsBinary() ST_AsText() ST_Boundary() ST_Buffer() ST_Centroid() ST_ConvexHull() ST_CoordDim() ST_Dimension() ST_EndPoint() ST_Envelope() ST_EnvelopeAsPts() ST_ExteriorRing() ST_Geometries() ST_GeometryFromText() ST_GeometryN() ST_GeometryType() ST_GeomFromBinary() ST_InteriorRingN() ST_InteriorRings() ST_IsClosed() ST_IsEmpty() ST_IsRing() ST_IsSimple() ST_IsValid() ST_Length() ST_LineFromText() ST_LineString() ST_MultiPoint() ST_NumGeometries() ST_NumInteriorRing() ST_NumPoints() ST_PointN() ST_Points() ST_Polygon() ST_StartPoint() ST_X() ST_XMax() ST_XMin() ST_Y() ST_YMax() ST_YMin() starts_with() stddev() stddev_pop() stddev_samp() strpos() substr() substring() sum() tan() tanh() tdigest_agg() timezone_hour() timezone_minute() to_base() to_base64() to_base64url() to_big_endian_32() to_big_endian_64() to_char() to_date() to_encoded_polyline() to_geometry() to_hex() to_ieee754_32() to_ieee754_64() to_iso8601() to_milliseconds() to_spherical_geography() to_timestamp() to_unixtime() to_utf8() transform() transform_keys() transform_values() translate() trim() truncate() try() try_cast() typeof() upper() url_decode() url_encode() url_extract_fragment() url_extract_host() url_extract_parameter() url_extract_path() url_extract_port() url_extract_protocol() url_extract_query() uuid() value_at_quantile() values_at_quantiles() var_pop() var_samp() variance() week() week_of_year() width_bucket() wilson_interval_lower() wilson_interval_upper() with_timezone() word_stem() xxhash64() year() year_of_week() yow() zip() zip_with()

C

cardinality() built-in function cast() built-in function cbrt() built-in function ceil() built-in function ceiling() built-in function char2hexint() built-in function checksum() built-in function chr() built-in function classify() built-in function coalesce() built-in function codepoint() built-in function color() built-in function combinations() built-in function concat() built-in function concat_ws() built-in function contains() built-in function

contains_sequence() built-in function convex_hull_agg() built-in function corr() built-in function cos() built-in function cosh() built-in function cosine_similarity() 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 cume_dist() built-in function current_date (built-in variable) current_time (built-in variable) current_timestamp (built-in variable) current_timezone() built-in function current_user (built-in variable)

D

date() built-in function date_add() built-in function date_diff() built-in function date_format() built-in function date_parse() built-in function date_trunc() 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 degrees() built-in function dense_rank() built-in function dow() built-in function doy() built-in function

E

e() built-in function element_at() built-in function empty_approx_set() built-in function

every() built-in function exp() built-in function extract() built-in function

F

features() built-in function filter() built-in function first_value() built-in function flatten() built-in function floor() built-in function format() built-in function 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_encoded_polyline() 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_iso8601_timestamp_nanos() built-in function from_unixtime() built-in function from_unixtime_nanos() built-in function from_utf8() built-in function

G

geometric_mean() built-in function geometry_from_hadoop_shape() built-in function geometry_invalid_reason() built-in function geometry_to_bing_tiles() built-in function

geometry_union() built-in function geometry_union_agg() built-in function great_circle_distance() built-in function greatest() built-in function

H

hamming_distance() 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 human_readable_seconds() built-in function

I

if() built-in function index() built-in function infinity() built-in function inverse_beta_cdf() built-in function inverse_normal_cdf() built-in function

is_finite() built-in function is_infinite() built-in function is_json_scalar() built-in function is_nan() 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_parse() built-in function json_size() built-in function

K

kurtosis() built-in function

L

lag() built-in function last_day_of_month() built-in function last_value() built-in function lead() built-in function learn_classifier() built-in function learn_libsvm_classifier() built-in function learn_libsvm_regressor() built-in function learn_regressor() built-in function least() built-in function length() built-in function levenshtein_distance() built-in function line_interpolate_point() built-in function

line_interpolate_points() built-in function line_locate_point() built-in function ln() built-in function localtime (built-in variable) localtimestamp (built-in variable) log() built-in function log10() built-in function log2() built-in function lower() built-in function lpad() built-in function ltrim() built-in function luhn_check() built-in function

M

map() built-in function map_agg() built-in function map_concat() built-in function map_entries() built-in function map_filter() built-in function map_from_entries() built-in function map_keys() built-in function map_union() built-in function map_values() built-in function map_zip_with() built-in function max() built-in function max_by() built-in function

md5() built-in function merge() built-in function millisecond() built-in function min() built-in function min_by() built-in function minute() built-in function mod() built-in function month() built-in function multimap_agg() built-in function multimap_from_entries() built-in function murmur3() built-in function

N

nan() built-in function ngrams() built-in function none_match() built-in function normal_cdf() built-in function normalize() built-in function

now() built-in function nth_value() built-in function ntile() built-in function nullif() built-in function numeric_histogram() built-in function

P

parse_datetime() built-in function parse_duration() built-in function parse_presto_data_size() built-in function percent_rank() built-in function

pi() built-in function position() built-in function pow() built-in function power() built-in function

Q

qdigest_agg() built-in function

quarter() built-in function

R

radians() built-in function rand() built-in function random() built-in function rank() built-in function reduce() built-in function reduce_agg() built-in function regexp_count() built-in function regexp_extract() built-in function regexp_extract_all() built-in function regexp_like() built-in function regexp_position() built-in function regexp_replace() built-in function regexp_split() built-in function regr_intercept() built-in function regr_slope() built-in function regress() built-in function

render() built-in function repeat() built-in function replace() built-in function reverse() built-in function RFC RFC 1866#section-8.2.1 RFC 2396 RFC 2822 RFC 4122 RFC 4291#section-2.5.5.2 RFC 4627, [1] RFC 4648 RFC 5952 RFC 7159, [1] RFC 7239 rgb() built-in function round() built-in function row_number() built-in function rpad() built-in function rtrim() built-in function runtime.kill_query() built-in function

S

second() built-in function sequence() built-in function sha1() built-in function sha256() built-in function sha512() built-in function shuffle() built-in function sign() built-in function simplify_geometry() built-in function sin() built-in function skewness() built-in function slice() built-in function split() built-in function split_part() built-in function split_to_map() built-in function split_to_multimap() built-in function spooky_hash_v2_32() built-in function spooky_hash_v2_64() built-in function sqrt() built-in function ST_Area() built-in function ST_AsBinary() built-in function ST_AsText() built-in function ST_Boundary() built-in function ST_Buffer() built-in function ST_Centroid() built-in function ST_ConvexHull() built-in function ST_CoordDim() built-in function ST_Dimension() built-in function ST_EndPoint() built-in function ST_Envelope() built-in function ST_EnvelopeAsPts() built-in function ST_ExteriorRing() built-in function ST_Geometries() built-in function ST_GeometryFromText() built-in function ST_GeometryN() built-in function

ST_GeometryType() built-in function ST_GeomFromBinary() built-in function ST_InteriorRingN() built-in function ST_InteriorRings() built-in function ST_IsClosed() built-in function ST_IsEmpty() built-in function ST_IsRing() built-in function ST_IsSimple() built-in function ST_IsValid() built-in function ST_Length() built-in function ST_LineFromText() built-in function ST_LineString() built-in function ST_MultiPoint() built-in function ST_NumGeometries() built-in function ST_NumInteriorRing() built-in function ST_NumPoints() built-in function ST_PointN() built-in function ST_Points() built-in function ST_Polygon() built-in function ST_StartPoint() built-in function ST_X() built-in function ST_XMax() built-in function ST_XMin() built-in function ST_Y() built-in function ST_YMax() built-in function ST_YMin() built-in function starts_with() built-in function stddev() built-in function stddev_pop() built-in function stddev_samp() built-in function strpos() built-in function substr() built-in function substring() built-in function sum() built-in function

T

tan() built-in function tanh() built-in function tdigest_agg() 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_char() built-in function to_date() built-in function to_encoded_polyline() built-in function to_geometry() 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_spherical_geography() built-in function to_timestamp() built-in function to_unixtime() built-in function to_utf8() built-in function transform() built-in function transform_keys() built-in function transform_values() built-in function translate() built-in function trim() built-in function truncate() built-in function try() built-in function try_cast() built-in function typeof() built-in function

U

upper() built-in function url_decode() built-in function url_encode() built-in function 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

V

value_at_quantile() built-in function values_at_quantiles() built-in function 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 width_bucket() built-in function wilson_interval_lower() built-in function

wilson_interval_upper() built-in function with_timezone() built-in function word_stem() built-in function

X

xxhash64() built-in function

Y

year() built-in function year_of_week() built-in function

yow() built-in function

Z

zip() built-in function

zip_with() built-in function