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_first()
• array_histogram()
• array_intersect()
• array_join()
• array_last()
• 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_distance()
• 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()
• ends_with()
• 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_collect_agg()
• 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()
• random_string(), catalog function of the Faker connector
• 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::fields()
• 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_AsEWKB()
• ST_AsEWKT()
• ST_AsText()
• ST_Boundary()
• ST_Buffer()
• ST_Centroid()
• ST_Collect()
• 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_Force2D()
• ST_Force3D()
• ST_Geometries()
• ST_GeometryFromText()
• ST_GeometryN()
• ST_GeometryType()
• ST_GeomFromBinary()
• ST_GeomFromEWKT()
• ST_GeomFromKML()
• ST_InteriorRingN()
• ST_InteriorRings()
• ST_Intersection()
• ST_Intersects()
• ST_IsClosed()
• ST_IsEmpty()
• ST_IsRing()
• ST_IsSimple()
• ST_IsValid()
• ST_Length()
• ST_LineFromText()
• ST_LineMerge()
• ST_LineString()
• ST_MakeLine()
• ST_MakePolygon()
• ST_MinimumBoundingCircle()
• ST_Multi()
• ST_MultiPoint()
• ST_Normalize()
• ST_NumGeometries()
• ST_NumInteriorRing()
• ST_NumPoints()
• ST_OrientedEnvelope()
• ST_Overlaps()
• ST_Point()
• ST_PointN()
• ST_PointOnSurface()
• ST_Points()
• ST_Polygon()
• ST_Polygonize()
• ST_Relate()
• ST_ReducePrecision()
• ST_SetSRID()
• ST_SRID()
• ST_StartPoint()
• ST_SymDifference()
• ST_Touches()
• ST_Transform()
• ST_Union()
• ST_VoronoiPolygons()
• ST_Within()
• ST_X()
• ST_XMax()
• ST_XMin()
• ST_Y()
• ST_YMax()
• ST_YMin()
• ST_Z()
• starts_with()
• stddev()
• stddev_pop()
• stddev_samp()
• strpos()
• substr()
• substring()
• sum()

T

• tan()
• tanh()
• tdigest_agg()
• theta_sketch_cardinality()
• theta_sketch_union()
• timestamp_objectid()
• timezone()
• timezone_hour()
• timezone_minute()
• title_case()
• 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()