List of Functions and Operators# ## [] substring operator || concatenation operator < comparison operator > comparison operator <= comparison operator >= comparison operator = comparison operator <> comparison operator = comparison operator <comparison_operators> -> 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_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_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() classify() 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_date 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() every() extract() exp() F# features() 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# hamming_distance() histogram() hmac_md5() hmac_sha1() hmac_sha256() hmac_sha512() hour() 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# kurtosis() L# lag() 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() ln() localtime localtimestamp log() 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# OR P# parse_datetime() parse_duration() parse_presto_data_size() percent_rank() pi() position() pow() power() 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() 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() translate() 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# value_at_quantile() values_at_quantiles() var_pop() var_samp() variance() 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()