7.26. List of Functions and Operators#
- [] substring operator
- || concatentation operator
- < comparison operator
- > comparison operator
- <= comparison operator
- >= comparison operator
- = comparsion 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()approx_distinct()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_zoom_level()bing_tiles_around()bit_count()bitwise_and()bitwise_not()bitwise_or()bitwise_xor()bitwise_and_agg()bitwise_or_agg()bool_and()bool_or()
C
cardinality()- CASE
cast()cbrt()ceil()ceiling()checksum()char2hexint()chr()- coalesce
codepoint()color()combinations()concat()contains()convex_hull_agg()corr()cos()cosh()cosine_similarity()count()count_if()covar_samp()covar_pop()crc32()cume_dist()current_datecurrent_timecurrent_timestampcurrent_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
F
filter()first_value()flatten()floor()format()from_base()from_base64()from_base64url()from_big_endian_32()from_big_endian_64()from_encoded_polyline()from_hex()from_ieee754_32()from_ieee754_64()from_iso8601_date()from_iso8601_timestamp()from_unixtime()from_utf8()
G
geometric_mean()geometry_from_hadoop_shape()geometry_invalid_reason()geometry_to_bing_tiles()geometry_union()geometry_union_agg()great_circle_distance()greatest()
H
I
- if
index()infinity()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
json_array_contains()json_array_get()json_array_length()json_extract()json_extract_scalar()json_format()json_parse()json_size()
K
L
lag()last_day_of_month()last_value()lead()least()length()levenshtein_distance()line_interpolate_point()line_interpolate_points()ln()localtimelocaltimestamplog()log10()log2()lower()lpad()ltrim()
M
map()map_agg()map_concat()map_entries()map_filter()map_from_entries()map_keys()map_values()map_zip_with()max()max_by()md5()merge()millisecond()min()min_by()minute()mod()month()multimap_agg()multimap_from_entries()
N
nan()ngrams()none_match()normal_cdf()normalize()- NOT
- NOT BETWEEN
now()nth_value()ntile()- nullif
numeric_histogram()
O
P
parse_datetime()parse_duration()parse_presto_data_size()percent_rank()pi()position()pow()power()
Q
R
radians()rand()random()rank()reduce()reduce_agg()regexp_count()regexp_extract()regexp_extract_all()regexp_like()regexp_position()regexp_replace()regexp_split()regr_intercept()regr_slope()render()repeat()replace()reverse()rgb()round()row_number()rpad()rtrim()
S
second()sequence()sha1()sha256()sha512()shuffle()sign()simplify_geometry()sin()slice()skewness()- SOME
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_GeometryN()ST_GeometryFromText()ST_GeometryType()ST_GeomFromBinary()ST_InteriorRingN()ST_InteriorRings()ST_Intersection()ST_Intersects()ST_IsClosed()ST_IsEmpty()ST_IsSimple()ST_IsRing()ST_IsValid()ST_Length()ST_LineFromText()ST_LineString()ST_MultiPoint()ST_NumGeometries()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()timezone_hour()timezone_minute()to_base()to_base64()to_big_endian_32()to_big_endian_64()to_char()to_date()to_encoded_polyline()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()trim()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_port()url_extract_query()uuid()
V
W
week()week_of_year()width_bucket()wilson_interval_lower()wilson_interval_upper()with_timezone()word_stem()
X
Y
Z