Presto 0.201 Documentation

Index

Index

A | B | C | D | E | F | G | H | I | J | K | L | M | N | P | Q | R | S | T | U | V | W | X | Y | Z

A

abs() (built-in function)
acos() (built-in function)
approx_distinct() (built-in function), [1]
approx_percentile() (built-in function), [1], [2], [3], [4]
arbitrary() (built-in function)
array_agg() (built-in function)
array_distinct() (built-in function)
array_except() (built-in function)
array_intersect() (built-in function)
array_join() (built-in function)
array_max() (built-in function)
array_min() (built-in function)
array_position() (built-in function)
array_remove() (built-in function)
array_sort() (built-in function), [1]
array_union() (built-in function)
arrays_overlap() (built-in function)
asin() (built-in function)
atan() (built-in function)
atan2() (built-in function)
avg() (built-in function), [1]

B

bar() (built-in function), [1]
bing_tile() (built-in function), [1]
bing_tile_at() (built-in function)
bing_tile_coordinates() (built-in function)
bing_tile_polygon() (built-in function)
bing_tile_quadkey() (built-in function)
bing_tile_zoom_level() (built-in function)
bit_count() (built-in function)
bitwise_and() (built-in function)
bitwise_and_agg() (built-in function)
bitwise_not() (built-in function)
bitwise_or() (built-in function)
bitwise_or_agg() (built-in function)
bitwise_xor() (built-in function)
bool_and() (built-in function)
bool_or() (built-in function)

C

cardinality() (built-in function)
cast() (built-in function)
cbrt() (built-in function)
ceil() (built-in function)
ceiling() (built-in function)
char2hexint() (built-in function)
checksum() (built-in function)
chr() (built-in function)
coalesce() (built-in function)
codepoint() (built-in function)
color() (built-in function), [1], [2]
concat() (built-in function)
contains() (built-in function)
corr() (built-in function)
cos() (built-in function)
cosh() (built-in function)
cosine_similarity() (built-in function)
count() (built-in function), [1]
count_if() (built-in function)
covar_pop() (built-in function)
covar_samp() (built-in function)
crc32() (built-in function)
cume_dist() (built-in function)
current_timezone() (built-in function)

D

date() (built-in function)
date_add() (built-in function)
date_diff() (built-in function)
date_format() (built-in function)
date_parse() (built-in function)
date_trunc() (built-in function)
day() (built-in function)
day_of_month() (built-in function)
day_of_week() (built-in function)
day_of_year() (built-in function)
degrees() (built-in function)
dense_rank() (built-in function)
dow() (built-in function)
doy() (built-in function)

E

e() (built-in function)
element_at() (built-in function)
every() (built-in function)
exp() (built-in function)
extract() (built-in function)

F

filter() (built-in function)
first_value() (built-in function)
flatten() (built-in function)
floor() (built-in function)
format_datetime() (built-in function)
from_base() (built-in function)
from_base64() (built-in function)
from_base64url() (built-in function)
from_big_endian_64() (built-in function)
from_hex() (built-in function)
from_ieee754_32() (built-in function)
from_ieee754_64() (built-in function)
from_iso8601_date() (built-in function)
from_iso8601_timestamp() (built-in function)
from_unixtime() (built-in function), [1], [2]
from_utf8() (built-in function), [1]

G

geometric_mean() (built-in function)
geometry_invalid_reason() (built-in function)
geometry_to_bing_tiles() (built-in function)
great_circle_distance() (built-in function)
greatest() (built-in function)

H

hamming_distance() (built-in function)
histogram() (built-in function)
hmac_md5() (built-in function)
hmac_sha1() (built-in function)
hmac_sha256() (built-in function)
hmac_sha512() (built-in function)
hour() (built-in function)

I

if() (built-in function), [1]
index() (built-in function)
infinity() (built-in function)
inverse_normal_cdf() (built-in function)
is_finite() (built-in function)
is_infinite() (built-in function)
is_json_scalar() (built-in function)
is_nan() (built-in function)

J

json_array_contains() (built-in function)
json_array_get() (built-in function)
json_array_length() (built-in function)
json_extract() (built-in function)
json_extract_scalar() (built-in function)
json_format() (built-in function)
json_parse() (built-in function)
json_size() (built-in function)

K

kurtosis() (built-in function)

L

lag() (built-in function)
last_value() (built-in function)
lead() (built-in function)
least() (built-in function)
length() (built-in function)
levenshtein_distance() (built-in function)
line_locate_point() (built-in function)
ln() (built-in function)
log10() (built-in function)
log2() (built-in function)
lower() (built-in function)
lpad() (built-in function)
ltrim() (built-in function)

M

map() (built-in function), [1]
map_agg() (built-in function)
map_concat() (built-in function)
map_entries() (built-in function)
map_filter() (built-in function)
map_from_entries() (built-in function)
map_keys() (built-in function)
map_union() (built-in function)
map_values() (built-in function)
map_zip_with() (built-in function)
max() (built-in function), [1]
max_by() (built-in function), [1]
md5() (built-in function)
min() (built-in function), [1]
min_by() (built-in function), [1]
minute() (built-in function)
mod() (built-in function)
month() (built-in function)
multimap_agg() (built-in function)

N

nan() (built-in function)
normal_cdf() (built-in function)
normalize() (built-in function), [1]
now() (built-in function)
nth_value() (built-in function)
ntile() (built-in function)
nullif() (built-in function)
numeric_histogram() (built-in function), [1]

P

parse_datetime() (built-in function)
parse_duration() (built-in function)
percent_rank() (built-in function)
pi() (built-in function)
position() (built-in function)
pow() (built-in function)
power() (built-in function)

Q

quarter() (built-in function)

R

radians() (built-in function)
rand() (built-in function)
random() (built-in function), [1]
rank() (built-in function)
reduce() (built-in function)
regexp_extract() (built-in function), [1]
regexp_extract_all() (built-in function), [1]
regexp_like() (built-in function)
regexp_replace() (built-in function), [1], [2]
regexp_split() (built-in function)
regr_intercept() (built-in function)
regr_slope() (built-in function)
render() (built-in function), [1]
repeat() (built-in function)
replace() (built-in function), [1]
reverse() (built-in function)
RFC
RFC 1866#section-8.2.1
RFC 2396
RFC 2822
RFC 4291#section-2.5.5.2
RFC 4627
RFC 5952
RFC 7159, [1]
rgb() (built-in function)
round() (built-in function), [1]
row_number() (built-in function)
rpad() (built-in function)
rtrim() (built-in function)
runtime.kill_query() (built-in function)

S

second() (built-in function)
sequence() (built-in function), [1], [2], [3], [4]
sha1() (built-in function)
sha256() (built-in function)
sha512() (built-in function)
shuffle() (built-in function)
sign() (built-in function)
simplify_geometry() (built-in function)
sin() (built-in function)
skewness() (built-in function)
slice() (built-in function)
split() (built-in function), [1]
split_part() (built-in function)
split_to_map() (built-in function)
sqrt() (built-in function)
ST_Area() (built-in function)
ST_AsText() (built-in function)
ST_Boundary() (built-in function)
ST_Buffer() (built-in function)
ST_Centroid() (built-in function)
ST_Contains() (built-in function)
ST_CoordDim() (built-in function)
ST_Crosses() (built-in function)
ST_Difference() (built-in function)
ST_Dimension() (built-in function)
ST_Disjoint() (built-in function)
ST_Distance() (built-in function)
ST_EndPoint() (built-in function)
ST_Envelope() (built-in function)
ST_Equals() (built-in function)
ST_ExteriorRing() (built-in function)
ST_GeometryFromText() (built-in function)
ST_GeometryType() (built-in function)
ST_Intersection() (built-in function)
ST_Intersects() (built-in function)
ST_IsClosed() (built-in function)
ST_IsEmpty() (built-in function)
ST_IsRing() (built-in function)
ST_IsSimple() (built-in function)
ST_IsValid() (built-in function)
ST_Length() (built-in function)
ST_LineFromText() (built-in function)
ST_NumInteriorRing() (built-in function)
ST_NumPoints() (built-in function)
ST_Overlaps() (built-in function)
ST_Point() (built-in function)
ST_Polygon() (built-in function)
ST_Relate() (built-in function)
ST_StartPoint() (built-in function)
ST_SymDifference() (built-in function)
ST_Touches() (built-in function)
ST_Within() (built-in function)
ST_X() (built-in function)
ST_XMax() (built-in function)
ST_XMin() (built-in function)
ST_Y() (built-in function)
ST_YMax() (built-in function)
ST_YMin() (built-in function)
stddev() (built-in function)
stddev_pop() (built-in function)
stddev_samp() (built-in function)
strpos() (built-in function)
substr() (built-in function), [1]
substring() (built-in function), [1]
sum() (built-in function)

T

tan() (built-in function)
tanh() (built-in function)
timezone_hour() (built-in function)
timezone_minute() (built-in function)
to_base() (built-in function)
to_base64() (built-in function)
to_base64url() (built-in function)
to_big_endian_64() (built-in function)
to_char() (built-in function)
to_date() (built-in function)
to_hex() (built-in function)
to_ieee754_32() (built-in function)
to_ieee754_64() (built-in function)
to_iso8601() (built-in function)
to_milliseconds() (built-in function)
to_timestamp() (built-in function)
to_unixtime() (built-in function)
to_utf8() (built-in function)
transform() (built-in function)
transform_keys() (built-in function)
transform_values() (built-in function)
trim() (built-in function)
truncate() (built-in function)
try() (built-in function)
try_cast() (built-in function)
typeof() (built-in function)

U

upper() (built-in function)
url_decode() (built-in function)
url_encode() (built-in function)
url_extract_fragment() (built-in function)
url_extract_host() (built-in function)
url_extract_parameter() (built-in function)
url_extract_path() (built-in function)
url_extract_port() (built-in function)
url_extract_protocol() (built-in function)
url_extract_query() (built-in function)

V

var_pop() (built-in function)
var_samp() (built-in function)
variance() (built-in function)

W

week() (built-in function)
week_of_year() (built-in function)
width_bucket() (built-in function), [1]
word_stem() (built-in function), [1]

X

xxhash64() (built-in function)

Y

year() (built-in function)
year_of_week() (built-in function)
yow() (built-in function)

Z

zip() (built-in function)
zip_with() (built-in function)