Functions and Operators
List of functions and operators
[] substring operator <subscript_operator>
{.interpreted-textrole=“ref”}|| concatenation operator <concatenation_operator>
{.interpreted-textrole=“ref”}\< comparison operator <comparison_operators>
{.interpreted-textrole=“ref”}\> comparison operator <comparison_operators>
{.interpreted-textrole=“ref”}<= comparison operator <comparison_operators>
{.interpreted-textrole=“ref”}>= comparison operator <comparison_operators>
{.interpreted-textrole=“ref”}= comparison operator <comparison_operators>
{.interpreted-textrole=“ref”}<> comparison operator <comparison_operators>
{.interpreted-textrole=“ref”}\!= comparison operator <comparison_operators>
{.interpreted-textrole=“ref”}-> lambda expression <lambda_expressions>
{.interpreted-textrole=“ref”}+ mathematical operator <mathematical_operators>
{.interpreted-textrole=“ref”}- mathematical operator <mathematical_operators>
{.interpreted-textrole=“ref”}* mathematical operator <mathematical_operators>
{.interpreted-textrole=“ref”}/ mathematical operator <mathematical_operators>
{.interpreted-textrole=“ref”}% mathematical operator <mathematical_operators>
{.interpreted-textrole=“ref”}
A
abs
{.interpreted-text role=“func”}acos
{.interpreted-text role=“func”}ALL <quantified_comparison_predicates>
{.interpreted-textrole=“ref”}all_match
{.interpreted-text role=“func”}AND <logical_operators>
{.interpreted-text role=“ref”}ANY <quantified_comparison_predicates>
{.interpreted-textrole=“ref”}any_match
{.interpreted-text role=“func”}approx_distinct
{.interpreted-text role=“func”}approx_most_frequent
{.interpreted-text role=“func”}approx_percentile
{.interpreted-text role=“func”}approx_set
{.interpreted-text role=“func”}arbitrary
{.interpreted-text role=“func”}array_agg
{.interpreted-text role=“func”}array_distinct
{.interpreted-text role=“func”}array_except
{.interpreted-text role=“func”}array_intersect
{.interpreted-text role=“func”}array_join
{.interpreted-text role=“func”}array_max
{.interpreted-text role=“func”}array_min
{.interpreted-text role=“func”}array_position
{.interpreted-text role=“func”}array_remove
{.interpreted-text role=“func”}array_sort
{.interpreted-text role=“func”}array_union
{.interpreted-text role=“func”}arrays_overlap
{.interpreted-text role=“func”}asin
{.interpreted-text role=“func”}AT TIME ZONE <at_time_zone_operator>
{.interpreted-text role=“ref”}at_timezone
{.interpreted-text role=“func”}atan
{.interpreted-text role=“func”}atan2
{.interpreted-text role=“func”}avg
{.interpreted-text role=“func”}
B
bar
{.interpreted-text role=“func”}beta_cdf
{.interpreted-text role=“func”}BETWEEN <range_operator>
{.interpreted-text role=“ref”}bing_tile
{.interpreted-text role=“func”}bing_tile_at
{.interpreted-text role=“func”}bing_tile_coordinates
{.interpreted-text role=“func”}bing_tile_polygon
{.interpreted-text role=“func”}bing_tile_quadkey
{.interpreted-text role=“func”}bing_tile_zoom_level
{.interpreted-text role=“func”}bing_tiles_around
{.interpreted-text role=“func”}bit_count
{.interpreted-text role=“func”}bitwise_and
{.interpreted-text role=“func”}bitwise_and_agg
{.interpreted-text role=“func”}bitwise_left_shift
{.interpreted-text role=“func”}bitwise_not
{.interpreted-text role=“func”}bitwise_or
{.interpreted-text role=“func”}bitwise_or_agg
{.interpreted-text role=“func”}bitwise_right_shift
{.interpreted-text role=“func”}bitwise_right_shift_arithmetic
{.interpreted-text role=“func”}bitwise_xor
{.interpreted-text role=“func”}bool_and
{.interpreted-text role=“func”}bool_or
{.interpreted-text role=“func”}
C
cardinality
{.interpreted-text role=“func”}CASE <case_expression>
{.interpreted-text role=“ref”}cast
{.interpreted-text role=“func”}cbrt
{.interpreted-text role=“func”}ceil
{.interpreted-text role=“func”}ceiling
{.interpreted-text role=“func”}char2hexint
{.interpreted-text role=“func”}checksum
{.interpreted-text role=“func”}chr
{.interpreted-text role=“func”}classify
{.interpreted-text role=“func”}coalesce <coalesce_function>
{.interpreted-text role=“ref”}codepoint
{.interpreted-text role=“func”}color
{.interpreted-text role=“func”}combinations
{.interpreted-text role=“func”}concat
{.interpreted-text role=“func”}concat_ws
{.interpreted-text role=“func”}contains
{.interpreted-text role=“func”}contains_sequence
{.interpreted-text role=“func”}convex_hull_agg
{.interpreted-text role=“func”}corr
{.interpreted-text role=“func”}cos
{.interpreted-text role=“func”}cosh
{.interpreted-text role=“func”}cosine_similarity
{.interpreted-text role=“func”}count
{.interpreted-text role=“func”}count_if
{.interpreted-text role=“func”}covar_pop
{.interpreted-text role=“func”}covar_samp
{.interpreted-text role=“func”}crc32
{.interpreted-text role=“func”}cume_dist
{.interpreted-text role=“func”}current_date
{.interpreted-text role=“data”}current_groups
{.interpreted-text role=“func”}current_time
{.interpreted-text role=“data”}current_timestamp
{.interpreted-text role=“data”}current_timezone
{.interpreted-text role=“func”}current_user
{.interpreted-text role=“data”}
D
date
{.interpreted-text role=“func”}date_add
{.interpreted-text role=“func”}date_diff
{.interpreted-text role=“func”}date_format
{.interpreted-text role=“func”}date_parse
{.interpreted-text role=“func”}date_trunc
{.interpreted-text role=“func”}day
{.interpreted-text role=“func”}day_of_month
{.interpreted-text role=“func”}day_of_week
{.interpreted-text role=“func”}day_of_year
{.interpreted-text role=“func”}DECIMAL <decimal_literal>
{.interpreted-text role=“ref”}degrees
{.interpreted-text role=“func”}dense_rank
{.interpreted-text role=“func”}dow
{.interpreted-text role=“func”}doy
{.interpreted-text role=“func”}
E
e
{.interpreted-text role=“func”}element_at
{.interpreted-text role=“func”}empty_approx_set
{.interpreted-text role=“func”}evaluate_classifier_predictions
every
{.interpreted-text role=“func”}extract
{.interpreted-text role=“func”}exp
{.interpreted-text role=“func”}
F
features
{.interpreted-text role=“func”}filter
{.interpreted-text role=“func”}f_value
{.interpreted-text role=“func”}flatten
{.interpreted-text role=“func”}floor
{.interpreted-text role=“func”}format
{.interpreted-text role=“func”}format_datetime
{.interpreted-text role=“func”}format_number
{.interpreted-text role=“func”}from_base
{.interpreted-text role=“func”}from_base32
{.interpreted-text role=“func”}from_base64
{.interpreted-text role=“func”}from_base64url
{.interpreted-text role=“func”}from_big_endian_32
{.interpreted-text role=“func”}from_big_endian_64
{.interpreted-text role=“func”}from_encoded_polyline
{.interpreted-text role=“func”}from_geojson_geometry
from_hex
{.interpreted-text role=“func”}from_ieee754_32
{.interpreted-text role=“func”}from_ieee754_64
{.interpreted-text role=“func”}from_iso8601_date
{.interpreted-text role=“func”}from_iso8601_timestamp
{.interpreted-text role=“func”}from_iso8601_timestamp_nanos
{.interpreted-text role=“func”}from_unixtime
{.interpreted-text role=“func”}from_unixtime_nanos
{.interpreted-text role=“func”}from_utf8
{.interpreted-text role=“func”}
G
geometric_mean
{.interpreted-text role=“func”}geometry_from_hadoop_shape
{.interpreted-text role=“func”}geometry_invalid_reason
{.interpreted-text role=“func”}geometry_nearest_points
{.interpreted-text role=“func”}geometry_to_bing_tiles
{.interpreted-text role=“func”}geometry_union
{.interpreted-text role=“func”}geometry_union_agg
{.interpreted-text role=“func”}great_circle_distance
{.interpreted-text role=“func”}greatest
{.interpreted-text role=“func”}
H
hamming_distance
{.interpreted-text role=“func”}hash_counts
{.interpreted-text role=“func”}histogram
{.interpreted-text role=“func”}hmac_md5
{.interpreted-text role=“func”}hmac_sha1
{.interpreted-text role=“func”}hmac_sha256
{.interpreted-text role=“func”}hmac_sha512
{.interpreted-text role=“func”}hour
{.interpreted-text role=“func”}human_readable_seconds
{.interpreted-text role=“func”}
I
if <if_function>
{.interpreted-text role=“ref”}index
{.interpreted-text role=“func”}infinity
{.interpreted-text role=“func”}intersection_cardinality
{.interpreted-text role=“func”}inverse_beta_cdf
{.interpreted-text role=“func”}inverse_normal_cdf
{.interpreted-text role=“func”}is_finite
{.interpreted-text role=“func”}is_infinite
{.interpreted-text role=“func”}is_json_scalar
{.interpreted-text role=“func”}is_nan
{.interpreted-text role=“func”}IS NOT DISTINCT <is_distinct_operator>
{.interpreted-textrole=“ref”}IS NOT NULL <is_null_operator>
{.interpreted-text role=“ref”}IS DISTINCT <is_distinct_operator>
{.interpreted-text role=“ref”}IS NULL <is_null_operator>
{.interpreted-text role=“ref”}
J
jaccard_index
{.interpreted-text role=“func”}json_array() <json_array>
{.interpreted-text role=“ref”}json_array_contains
{.interpreted-text role=“func”}json_array_get
{.interpreted-text role=“func”}json_array_length
{.interpreted-text role=“func”}json_exists() <json_exists>
{.interpreted-text role=“ref”}json_extract
{.interpreted-text role=“func”}json_extract_scalar
{.interpreted-text role=“func”}json_format
{.interpreted-text role=“func”}json_object() <json_object>
{.interpreted-text role=“ref”}json_parse
{.interpreted-text role=“func”}json_query() <json_query>
{.interpreted-text role=“ref”}json_size
{.interpreted-text role=“func”}json_value() <json_value>
{.interpreted-text role=“ref”}
K
kurtosis
{.interpreted-text role=“func”}
L
lag
{.interpreted-text role=“func”}last_day_of_month
{.interpreted-text role=“func”}last_value
{.interpreted-text role=“func”}lead
{.interpreted-text role=“func”}learn_classifier
{.interpreted-text role=“func”}learn_libsvm_classifier
{.interpreted-text role=“func”}learn_libsvm_regressor
{.interpreted-text role=“func”}learn_regressor
{.interpreted-text role=“func”}least
{.interpreted-text role=“func”}length
{.interpreted-text role=“func”}levenshtein_distance
{.interpreted-text role=“func”}line_interpolate_point
{.interpreted-text role=“func”}line_interpolate_points
{.interpreted-text role=“func”}line_locate_point
{.interpreted-text role=“func”}listagg
{.interpreted-text role=“func”}ln
{.interpreted-text role=“func”}localtime
{.interpreted-text role=“data”}localtimestamp
{.interpreted-text role=“data”}log
{.interpreted-text role=“func”}log10
{.interpreted-text role=“func”}log2
{.interpreted-text role=“func”}lower
{.interpreted-text role=“func”}lpad
{.interpreted-text role=“func”}ltrim
{.interpreted-text role=“func”}luhn_check
{.interpreted-text role=“func”}
M
make_set_digest
{.interpreted-text role=“func”}map
{.interpreted-text role=“func”}map_agg
{.interpreted-text role=“func”}map_concat
{.interpreted-text role=“func”}map_entries
{.interpreted-text role=“func”}map_filter
{.interpreted-text role=“func”}map_from_entries
{.interpreted-text role=“func”}map_keys
{.interpreted-text role=“func”}map_union
{.interpreted-text role=“func”}map_values
{.interpreted-text role=“func”}map_zip_with
{.interpreted-text role=“func”}max
{.interpreted-text role=“func”}max_by
{.interpreted-text role=“func”}md5
{.interpreted-text role=“func”}merge
{.interpreted-text role=“func”}merge_set_digest
{.interpreted-text role=“func”}millisecond
{.interpreted-text role=“func”}min
{.interpreted-text role=“func”}min_by
{.interpreted-text role=“func”}minute
{.interpreted-text role=“func”}mod
{.interpreted-text role=“func”}month
{.interpreted-text role=“func”}multimap_agg
{.interpreted-text role=“func”}multimap_from_entries
{.interpreted-text role=“func”}murmur3
{.interpreted-text role=“func”}
N
nan
{.interpreted-text role=“func”}ngrams
{.interpreted-text role=“func”}none_match
{.interpreted-text role=“func”}normal_cdf
{.interpreted-text role=“func”}normalize
{.interpreted-text role=“func”}NOT <logical_operators>
{.interpreted-text role=“ref”}NOT BETWEEN <range_operator>
{.interpreted-text role=“ref”}now
{.interpreted-text role=“func”}nth_value
{.interpreted-text role=“func”}ntile
{.interpreted-text role=“func”}nullif <nullif_function>
{.interpreted-text role=“ref”}numeric_histogram
{.interpreted-text role=“func”}
O
objectid
objectid_timestamp
{.interpreted-text role=“func”}OR <logical_operators>
{.interpreted-text role=“ref”}
P
parse_datetime
{.interpreted-text role=“func”}parse_duration
{.interpreted-text role=“func”}parse_data_size
{.interpreted-text role=“func”}percent_rank
{.interpreted-text role=“func”}pi
{.interpreted-text role=“func”}position
{.interpreted-text role=“func”}pow
{.interpreted-text role=“func”}power
{.interpreted-text role=“func”}
Q
qdigest_agg
{.interpreted-text role=“func”}quarter
{.interpreted-text role=“func”}
R
radians
{.interpreted-text role=“func”}rand
{.interpreted-text role=“func”}random
{.interpreted-text role=“func”}rank
{.interpreted-text role=“func”}reduce
{.interpreted-text role=“func”}reduce_agg
{.interpreted-text role=“func”}regexp_count
{.interpreted-text role=“func”}regexp_extract
{.interpreted-text role=“func”}regexp_extract_all
{.interpreted-text role=“func”}regexp_like
{.interpreted-text role=“func”}regexp_position
{.interpreted-text role=“func”}regexp_replace
{.interpreted-text role=“func”}regexp_split
{.interpreted-text role=“func”}regress
{.interpreted-text role=“func”}regr_intercept
{.interpreted-text role=“func”}regr_slope
{.interpreted-text role=“func”}render
{.interpreted-text role=“func”}repeat
{.interpreted-text role=“func”}replace
{.interpreted-text role=“func”}reverse
{.interpreted-text role=“func”}rgb
{.interpreted-text role=“func”}round
{.interpreted-text role=“func”}row_number
{.interpreted-text role=“func”}rpad
{.interpreted-text role=“func”}rtrim
{.interpreted-text role=“func”}
S
second
{.interpreted-text role=“func”}sequence
{.interpreted-text role=“func”}sha1
{.interpreted-text role=“func”}sha256
{.interpreted-text role=“func”}sha512
{.interpreted-text role=“func”}shuffle
{.interpreted-text role=“func”}sign
{.interpreted-text role=“func”}simplify_geometry
{.interpreted-text role=“func”}sin
{.interpreted-text role=“func”}skewness
{.interpreted-text role=“func”}slice
{.interpreted-text role=“func”}SOME <quantified_comparison_predicates>
{.interpreted-textrole=“ref”}soundex
{.interpreted-text role=“func”}spatial_partitioning
spatial_partitions
split
{.interpreted-text role=“func”}split_part
{.interpreted-text role=“func”}split_to_map
{.interpreted-text role=“func”}split_to_multimap
{.interpreted-text role=“func”}spooky_hash_v2_32
{.interpreted-text role=“func”}spooky_hash_v2_64
{.interpreted-text role=“func”}sqrt
{.interpreted-text role=“func”}ST_Area
{.interpreted-text role=“func”}ST_AsBinary
{.interpreted-text role=“func”}ST_AsText
{.interpreted-text role=“func”}ST_Boundary
{.interpreted-text role=“func”}ST_Buffer
{.interpreted-text role=“func”}ST_Centroid
{.interpreted-text role=“func”}ST_Contains
{.interpreted-text role=“func”}ST_ConvexHull
{.interpreted-text role=“func”}ST_CoordDim
{.interpreted-text role=“func”}ST_Crosses
{.interpreted-text role=“func”}ST_Difference
{.interpreted-text role=“func”}ST_Dimension
{.interpreted-text role=“func”}ST_Disjoint
{.interpreted-text role=“func”}ST_Distance
{.interpreted-text role=“func”}ST_EndPoint
{.interpreted-text role=“func”}ST_Envelope
{.interpreted-text role=“func”}ST_EnvelopeAsPts
{.interpreted-text role=“func”}ST_Equals
{.interpreted-text role=“func”}ST_ExteriorRing
{.interpreted-text role=“func”}ST_Geometries
{.interpreted-text role=“func”}ST_GeometryFromText
{.interpreted-text role=“func”}ST_GeometryN
{.interpreted-text role=“func”}ST_GeometryType
{.interpreted-text role=“func”}ST_GeomFromBinary
{.interpreted-text role=“func”}ST_InteriorRingN
{.interpreted-text role=“func”}ST_InteriorRings
{.interpreted-text role=“func”}ST_Intersection
{.interpreted-text role=“func”}ST_Intersects
{.interpreted-text role=“func”}ST_IsClosed
{.interpreted-text role=“func”}ST_IsEmpty
{.interpreted-text role=“func”}ST_IsRing
{.interpreted-text role=“func”}ST_IsSimple
{.interpreted-text role=“func”}ST_IsValid
{.interpreted-text role=“func”}ST_Length
{.interpreted-text role=“func”}ST_LineFromText
{.interpreted-text role=“func”}ST_LineString
{.interpreted-text role=“func”}ST_MultiPoint
{.interpreted-text role=“func”}ST_NumGeometries
{.interpreted-text role=“func”}ST_NumInteriorRing
ST_NumPoints
{.interpreted-text role=“func”}ST_Overlaps
{.interpreted-text role=“func”}ST_Point
{.interpreted-text role=“func”}ST_PointN
{.interpreted-text role=“func”}ST_Points
{.interpreted-text role=“func”}ST_Polygon
{.interpreted-text role=“func”}ST_Relate
{.interpreted-text role=“func”}ST_StartPoint
{.interpreted-text role=“func”}ST_SymDifference
{.interpreted-text role=“func”}ST_Touches
{.interpreted-text role=“func”}ST_Union
{.interpreted-text role=“func”}ST_Within
{.interpreted-text role=“func”}ST_X
{.interpreted-text role=“func”}ST_XMax
{.interpreted-text role=“func”}ST_XMin
{.interpreted-text role=“func”}ST_Y
{.interpreted-text role=“func”}ST_YMax
{.interpreted-text role=“func”}ST_YMin
{.interpreted-text role=“func”}starts_with
{.interpreted-text role=“func”}stddev
{.interpreted-text role=“func”}stddev_pop
{.interpreted-text role=“func”}stddev_samp
{.interpreted-text role=“func”}strpos
{.interpreted-text role=“func”}substr
{.interpreted-text role=“func”}substring
{.interpreted-text role=“func”}sum
{.interpreted-text role=“func”}
T
tan
{.interpreted-text role=“func”}tanh
{.interpreted-text role=“func”}tdigest_agg
{.interpreted-text role=“func”}timestamp_objectid
{.interpreted-text role=“func”}timezone_hour
{.interpreted-text role=“func”}timezone_minute
{.interpreted-text role=“func”}to_base
{.interpreted-text role=“func”}to_base32
{.interpreted-text role=“func”}to_base64
{.interpreted-text role=“func”}to_base64url
{.interpreted-text role=“func”}to_big_endian_32
{.interpreted-text role=“func”}to_big_endian_64
{.interpreted-text role=“func”}to_char
{.interpreted-text role=“func”}to_date
{.interpreted-text role=“func”}to_encoded_polyline
{.interpreted-text role=“func”}to_geojson_geometry
to_geometry
{.interpreted-text role=“func”}to_hex
{.interpreted-text role=“func”}to_ieee754_32
{.interpreted-text role=“func”}to_ieee754_64
{.interpreted-text role=“func”}to_iso8601
{.interpreted-text role=“func”}to_milliseconds
{.interpreted-text role=“func”}to_spherical_geography
{.interpreted-text role=“func”}to_timestamp
{.interpreted-text role=“func”}to_unixtime
{.interpreted-text role=“func”}to_utf8
{.interpreted-text role=“func”}transform
{.interpreted-text role=“func”}transform_keys
{.interpreted-text role=“func”}transform_values
{.interpreted-text role=“func”}translate
{.interpreted-text role=“func”}trim
{.interpreted-text role=“func”}trim_array
{.interpreted-text role=“func”}truncate
{.interpreted-text role=“func”}try <try_function>
{.interpreted-text role=“ref”}try_cast
{.interpreted-text role=“func”}typeof
{.interpreted-text role=“func”}
U
upper
{.interpreted-text role=“func”}url_decode
{.interpreted-text role=“func”}url_encode
{.interpreted-text role=“func”}url_extract_fragment
{.interpreted-text role=“func”}url_extract_host
{.interpreted-text role=“func”}url_extract_parameter
{.interpreted-text role=“func”}url_extract_path
{.interpreted-text role=“func”}url_extract_protocol
{.interpreted-text role=“func”}url_extract_port
{.interpreted-text role=“func”}url_extract_query
{.interpreted-text role=“func”}uuid
{.interpreted-text role=“func”}
V
value_at_quantile
{.interpreted-text role=“func”}values_at_quantiles
{.interpreted-text role=“func”}var_pop
{.interpreted-text role=“func”}var_samp
{.interpreted-text role=“func”}variance
{.interpreted-text role=“func”}version
{.interpreted-text role=“func”}
W
week
{.interpreted-text role=“func”}week_of_year
{.interpreted-text role=“func”}width_bucket
{.interpreted-text role=“func”}wilson_interval_lower
{.interpreted-text role=“func”}wilson_interval_upper
{.interpreted-text role=“func”}with_timezone
{.interpreted-text role=“func”}word_stem
{.interpreted-text role=“func”}
X
xxhash64
{.interpreted-text role=“func”}
Y
year
{.interpreted-text role=“func”}year_of_week
{.interpreted-text role=“func”}yow
{.interpreted-text role=“func”}
Z
zip
{.interpreted-text role=“func”}zip_with
{.interpreted-text role=“func”}
Was this page helpful?