• [] 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”}