List of functions and operators

#

• [] substring operator

• || concatenation operator

• < comparison operator

• > comparison operator

• <= comparison operator

• >= comparison operator

• = comparison operator

• <> comparison operator

• != comparison operator

• -> lambda expression

• + mathematical operator

• - mathematical operator

• * mathematical operator

• / mathematical operator

• % mathematical operator

A

• abs()

• acos()

• ALL

• all_match()

• AND

• ANY

• any_match()

• any_value()

• 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 TIME ZONE

• at_timezone()

• atan()

• atan2()

• avg()

B

• bar()

• beta_cdf()

• BETWEEN

• 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()

C

• cardinality()

• CASE

• cast()

• cbrt()

• ceil()

• ceiling()

• char2hexint()

• checksum()

• chr()

• classify()

• classifier

• 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_date

• current_groups()

• current_time

• current_timestamp

• current_timezone()

• current_user

D

• date()

• date_add()

• date_diff()

• date_format()

• date_parse()

• date_trunc()

• day()

• day_of_month()

• day_of_week()

• day_of_year()

• DECIMAL

• degrees()

• dense_rank()

• dow()

• doy()

E

• e()

• element_at()

• empty_approx_set()

• evaluate_classifier_predictions

• every()

• exclude_columns()

• extract()

• exp()

F

• features()

• filter()

• first

• first_value()

• flatten()

• floor()

• format()

• format_datetime()

• format_number()

• from_base()

• from_base32()

• from_base64()

• from_base64url()

• from_big_endian_32()

• from_big_endian_64()

• from_encoded_polyline()

• from_geojson_geometry

• 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()

G

• geometric_mean()

• geometry_from_hadoop_shape()

• geometry_invalid_reason()

• geometry_nearest_points()

• geometry_to_bing_tiles()

• geometry_union()

• geometry_union_agg()

• great_circle_distance()

• greatest()

H

• hamming_distance()

• hash_counts()

• histogram()

• hmac_md5()

• hmac_sha1()

• hmac_sha256()

• hmac_sha512()

• hour()

• human_readable_seconds()

I

• if

• index()

• infinity()

• intersection_cardinality()

• inverse_beta_cdf()

• inverse_normal_cdf()

• is_finite()

• is_infinite()

• is_json_scalar()

• is_nan()

• IS NOT DISTINCT

• IS NOT NULL

• IS DISTINCT

• IS NULL

J

• jaccard_index()

• json_array()

• json_array_contains()

• json_array_get()

• json_array_length()

• json_exists()

• json_extract()

• json_extract_scalar()

• json_format()

• json_object()

• json_parse()

• json_query()

• json_size()

• json_value()

K

• kurtosis()

L

• lag()

• last

• 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()

• listagg()

• ln()

• localtime

• localtimestamp

• log()

• log10()

• log2()

• lower()

• lpad()

• ltrim()

• luhn_check()

M

• make_set_digest()

• map()

• map_agg()

• map_concat()

• map_entries()

• map_filter()

• map_from_entries()

• map_keys()

• map_union()

• map_values()

• map_zip_with()

• match_number

• max()

• max_by()

• md5()

• merge()

• merge_set_digest()

• millisecond()

• min()

• min_by()

• minute()

• mod()

• month()

• multimap_agg()

• multimap_from_entries()

• murmur3()

N

• nan()

• next

• ngrams()

• none_match()

• normal_cdf()

• normalize()

• NOT

• NOT BETWEEN

• now()

• nth_value()

• ntile()

• nullif

• numeric_histogram()

O

• objectid

• objectid_timestamp()

• OR

P

• parse_datetime()

• parse_duration()

• parse_data_size()

• percent_rank()

• permute

• pi()

• position()

• pow()

• power()

• prev

Q

• qdigest_agg()

• quarter()

R

• radians()

• rand()

• random()

• rank()

• reduce()

• reduce_agg()

• regexp_count()

• regexp_extract()

• regexp_extract_all()

• regexp_like()

• regexp_position()

• regexp_replace()

• regexp_split()

• regress()

• regr_intercept()

• regr_slope()

• render()

• repeat()

• replace()

• reverse()

• rgb()

• round()

• row_number()

• rpad()

• rtrim()

S

• second()

• sequence() (scalar function)

• sequence() (table function)

• sha1()

• sha256()

• sha512()

• shuffle()

• sign()

• simplify_geometry()

• sin()

• sinh()

• skewness()

• slice()

• SOME

• soundex()

• spatial_partitioning

• spatial_partitions

• 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_Contains()

• ST_ConvexHull()

• ST_CoordDim()

• ST_Crosses()

• ST_Difference()

• ST_Dimension()

• ST_Disjoint()

• ST_Distance()

• ST_EndPoint()

• ST_Envelope()

• ST_EnvelopeAsPts()

• ST_Equals()

• ST_ExteriorRing()

• ST_Geometries()

• ST_GeometryFromText()

• ST_GeometryN()

• ST_GeometryType()

• ST_GeomFromBinary()

• ST_InteriorRingN()

• ST_InteriorRings()

• ST_Intersection()

• ST_Intersects()

• 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_Overlaps()

• ST_Point()

• ST_PointN()

• ST_Points()

• ST_Polygon()

• ST_Relate()

• ST_StartPoint()

• ST_SymDifference()

• ST_Touches()

• ST_Union()

• ST_Within()

• ST_X()

• ST_XMax()

• ST_XMin()

• ST_Y()

• ST_YMax()

• ST_YMin()

• starts_with()

• stddev()

• stddev_pop()

• stddev_samp()

• strpos()

• substr()

• substring()

• sum()

T

• tan()

• tanh()

• tdigest_agg()

• timestamp_objectid()

• timezone()

• timezone_hour()

• timezone_minute()

• to_base()

• to_base32()

• to_base64()

• to_base64url()

• to_big_endian_32()

• to_big_endian_64()

• to_char()

• to_date()

• to_encoded_polyline()

• to_geojson_geometry

• 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()

• trim_array()

• truncate()

• try

• try_cast()

• typeof()

U

• upper()

• url_decode()

• url_encode()

• url_extract_fragment()

• url_extract_host()

• url_extract_parameter()

• url_extract_path()

• url_extract_protocol()

• url_extract_port()

• url_extract_query()

• uuid()

V

• value_at_quantile()

• values_at_quantiles()

• var_pop()

• var_samp()

• variance()

• version()

W

• week()

• week_of_year()

• width_bucket()

• wilson_interval_lower()

• wilson_interval_upper()

• with_timezone()

• word_stem()

X

• xxhash64()

Y

• year()

• year_of_week()

• yow()

Z

• zip()

• zip_with()