[] 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_predictionsevery{.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_geometryfrom_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
objectidobjectid_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_partitioningspatial_partitionssplit{.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_NumInteriorRingST_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_geometryto_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”}

