SQL Functions and Operators¶
This section provides a comprehensive overview of the SQL functions and operators that are natively supported by Minerva. These built-in functions and operators empower users to perform various data manipulation, aggregation, and computation tasks directly within the Minerva environment, enhancing the efficiency and flexibility of data analysis workflows.
Refer to the following sections for further details:
Minerva SQL Functions and Operators: Alphabetical Reference
Minerva SQL Functions by Topic¶
Aggregate¶
For more details, see aggregate function
any_value
approx_distinct
approx_most_frequent
approx_percentile
approx_set
arbitrary
array_agg
avg
bitwise_and_agg
bitwise_or_agg
bool_and
bool_or
checksum
corr
count
count_if
covar_pop
covar_samp
every
geometric_mean
histogram
kurtosis
- 'list_agg
map_agg
map_union
max
max_by
merge
min
min_by
multimap_agg
numeric_histogram
qdigest_agg
regr_intercept
regr_slope
skewness
sum
stddev
stddev_pop
stddev_samp
tdigest_agg
variance
var_pop
var_samp
reduce_agg
Array¶
For more details, see array
all_match
any_match
array_distinct
array_except
array_intersect
array_join
array_max
array_min
array_position
array_remove
array_sort
array_union
arrays_overlap
cardinality
combinations
concat()
contains
element_at
filter
flatten
ngrams
none_match
reduce
repeat
reverse()
sequence
shuffle
slice
transform
trim_array
zip
zip_with
Binary¶
For more details, see binary
concat()
crc32
from_base32
from_base64
from_base64url
from_big_endian_32
from_big_endian_64
from_hex
from_ieee754_32
from_ieee754_64
hmac_md5
hmac_sha1
hmac_sha256
hmac_sha512
length()
lpad()
md5
murmur3
reverse()
rpad()
sha1
sha256
sha512
spooky_hash_v2_32
spooky_hash_v2_64
substr()
to_base32
to_base64
to_base64url
to_big_endian_32
to_big_endian_64
to_hex
to_ieee754_32
to_ieee754_64
xxhash64
Bitwise¶
For more details, see bitwise
bit_count
bitwise_and
bitwise_left_shift
bitwise_not
bitwise_or
bitwise_right_shift
bitwise_right_shift_arithmetic
bitwise_xor
Color¶
For more details, see color
Comparison¶
For more details, see comparison
Conditional¶
For more details, see conditional
Conversion¶
For more details, see conversion
Date and time¶
For more details, see date and time
AT TIME ZONE
current_date
current_time
current_timestamp
localtime
localtimestamp
current_timezone
date
date_add
date_diff
date_format
date_parse
date_trunc
format_datetime
HyperLogLog¶
For more details, see hyperloglog
Lambda¶
For more details, see lambda
Machine Learning¶
For more details, see machine learning
classify
features
learn_classifier
learn_libsvm_classifier
learn_libsvm_regressor
learn_regressor
regress
Map¶
For more details,see map
cardinality
element_at
map
map_concat
map_entries
map_filter
map_from_entries
map_keys
map_values
map_zip_with
multimap_from_entries
transform_keys
transform_values
Math¶
For more details, see maths
acos
asin
atan
beta_cdf
cbrt
ceil
cos
cosh
cosine_similarity
degrees
e
exp
floor
from_base
infinity
inverse_beta_cdf
inverse_normal_cdf
is_finite
is_nan
ln
log
log2
log10
mod
nan
normal_cdf
pi
pow
power
radians
rand
random
round
sign
sin
sinh
sqrt
tan
tanh
to_base
truncate
width_bucket
wilson_interval_lower
wilson_interval_upper
Quantile Digest¶
For more details, see quantile digest
Regular Expression¶
For more details, see regular expression
regexp_count
regexp_extract
regexp_extract_all
regexp_like
regexp_position
regexp_replace
regexp_split
Session¶
For more details, see session
Set Digest¶
For more details, see setdigest
String¶
For more details, see string
chr
codepoint
concat
concat_ws
format
from_utf8
hamming_distance
length
levenshtein_distance
lower
lpad
ltrim
luhn_check
normalize
position
replace
reverse
rpad
rtrim
soundex
split
split_part
split_to_map
split_to_multimap
starts_with
strpos
substr
substring
to_utf8
translate
trim
upper
word_stem
System¶
For more details, see system
T-Digest¶
For more details, see tdigest
Teradata¶
For more details, see teradata
URL¶
For more details, see url
url_decode
url_encode
url_extract_fragment
url_extract_host
url_extract_parameter
url_extract_path
url_extract_port
url_extract_protocol
url_extract_query
UUID¶
For more details, see uuid
Window¶
For more details, see window