Presto 329 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)
all_match() (built-in function)
any_match() (built-in function)
approx_distinct() (built-in function)
,
[1]
approx_percentile() (built-in function)
,
[1]
,
[2]
,
[3]
,
[4]
approx_set() (built-in function)
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)
at_timezone() (built-in function)
atan() (built-in function)
atan2() (built-in function)
avg() (built-in function)
,
[1]
B
bar() (built-in function)
,
[1]
beta_cdf() (built-in function)
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)
bing_tiles_around() (built-in function)
,
[1]
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]
combinations() (built-in function)
concat() (built-in function)
contains() (built-in function)
convex_hull_agg() (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_date() (built-in function)
current_time() (built-in function)
current_timestamp() (built-in function)
current_timezone() (built-in function)
current_user() (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)
empty_approx_set() (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() (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_32() (built-in function)
from_big_endian_64() (built-in function)
from_encoded_polyline() (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_from_hadoop_shape() (built-in function)
geometry_invalid_reason() (built-in function)
geometry_to_bing_tiles() (built-in function)
geometry_union() (built-in function)
geometry_union_agg() (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_beta_cdf() (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_day_of_month() (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_interpolate_point() (built-in function)
line_interpolate_points() (built-in function)
line_locate_point() (built-in function)
ln() (built-in function)
localtime() (built-in function)
localtimestamp() (built-in function)
log() (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)
merge() (built-in function)
millisecond() (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)
multimap_from_entries() (built-in function)
N
nan() (built-in function)
ngrams() (built-in function)
none_match() (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)
parse_presto_data_size() (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
qdigest_agg() (built-in function)
,
[1]
,
[2]
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)
reduce_agg() (built-in function)
regexp_count() (built-in function)
regexp_extract() (built-in function)
,
[1]
regexp_extract_all() (built-in function)
,
[1]
regexp_like() (built-in function)
regexp_position() (built-in function)
,
[1]
,
[2]
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 4122
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)
split_to_multimap() (built-in function)
spooky_hash_v2_32() (built-in function)
spooky_hash_v2_64() (built-in function)
sqrt() (built-in function)
ST_Area() (built-in function)
,
[1]
ST_AsBinary() (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_ConvexHull() (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)
,
[1]
ST_EndPoint() (built-in function)
ST_Envelope() (built-in function)
ST_EnvelopeAsPts() (built-in function)
ST_Equals() (built-in function)
ST_ExteriorRing() (built-in function)
ST_Geometries() (built-in function)
ST_GeometryFromText() (built-in function)
ST_GeometryN() (built-in function)
ST_GeometryType() (built-in function)
ST_GeomFromBinary() (built-in function)
ST_InteriorRingN() (built-in function)
ST_InteriorRings() (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)
,
[1]
ST_LineFromText() (built-in function)
ST_LineString() (built-in function)
ST_MultiPoint() (built-in function)
ST_NumGeometries() (built-in function)
ST_NumInteriorRing() (built-in function)
ST_NumPoints() (built-in function)
ST_Overlaps() (built-in function)
ST_Point() (built-in function)
ST_PointN() (built-in function)
ST_Points() (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_Union() (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)
,
[1]
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_32() (built-in function)
to_big_endian_64() (built-in function)
to_char() (built-in function)
to_date() (built-in function)
to_encoded_polyline() (built-in function)
to_geometry() (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_spherical_geography() (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)
uuid() (built-in function)
V
value_at_quantile() (built-in function)
values_at_quantiles() (built-in function)
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]
wilson_interval_lower() (built-in function)
wilson_interval_upper() (built-in function)
with_timezone() (built-in function)
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)
