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_valueapprox_distinctapprox_most_frequentapprox_percentileapprox_setarbitraryarray_aggavgbitwise_and_aggbitwise_or_aggbool_andbool_orchecksumcorrcountcount_ifcovar_popcovar_sampeverygeometric_meanhistogramkurtosis- 'list_agg
map_aggmap_unionmaxmax_bymergeminmin_bymultimap_aggnumeric_histogramqdigest_aggregr_interceptregr_slopeskewnesssumstddevstddev_popstddev_samptdigest_aggvariancevar_popvar_sampreduce_agg
Array¶
For more details, see array
all_matchany_matcharray_distinctarray_exceptarray_intersectarray_joinarray_maxarray_minarray_positionarray_removearray_sortarray_unionarrays_overlapcardinalitycombinationsconcat()containselement_atfilterflattenngramsnone_matchreducerepeatreverse()sequenceshuffleslicetransformtrim_arrayzipzip_with
Binary¶
For more details, see binary
concat()crc32from_base32from_base64from_base64urlfrom_big_endian_32from_big_endian_64from_hexfrom_ieee754_32from_ieee754_64hmac_md5hmac_sha1hmac_sha256hmac_sha512length()lpad()md5murmur3reverse()rpad()sha1sha256sha512spooky_hash_v2_32spooky_hash_v2_64substr()to_base32to_base64to_base64urlto_big_endian_32to_big_endian_64to_hexto_ieee754_32to_ieee754_64xxhash64
Bitwise¶
For more details, see bitwise
bit_countbitwise_andbitwise_left_shiftbitwise_notbitwise_orbitwise_right_shiftbitwise_right_shift_arithmeticbitwise_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 ZONEcurrent_datecurrent_timecurrent_timestamplocaltimelocaltimestampcurrent_timezonedatedate_adddate_diffdate_formatdate_parsedate_truncformat_datetime
HyperLogLog¶
For more details, see hyperloglog
Lambda¶
For more details, see lambda
Machine Learning¶
For more details, see machine learning
classifyfeatureslearn_classifierlearn_libsvm_classifierlearn_libsvm_regressorlearn_regressorregress
Map¶
For more details,see map
cardinalityelement_atmapmap_concatmap_entriesmap_filtermap_from_entriesmap_keysmap_valuesmap_zip_withmultimap_from_entriestransform_keystransform_values
Math¶
For more details, see maths
acosasinatanbeta_cdfcbrtceilcoscoshcosine_similaritydegreeseexpfloorfrom_baseinfinityinverse_beta_cdfinverse_normal_cdfis_finiteis_nanlnloglog2log10modnannormal_cdfpipowpowerradiansrandrandomroundsignsinsinhsqrttantanhto_basetruncatewidth_bucketwilson_interval_lowerwilson_interval_upper
Quantile Digest¶
For more details, see quantile digest
Regular Expression¶
For more details, see regular expression
regexp_countregexp_extractregexp_extract_allregexp_likeregexp_positionregexp_replaceregexp_split
Session¶
For more details, see session
Set Digest¶
For more details, see setdigest
String¶
For more details, see string
chrcodepointconcatconcat_wsformatfrom_utf8hamming_distancelengthlevenshtein_distancelowerlpadltrimluhn_checknormalizepositionreplacereverserpadrtrimsoundexsplitsplit_partsplit_to_mapsplit_to_multimapstarts_withstrpossubstrsubstringto_utf8translatetrimupperword_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_decodeurl_encodeurl_extract_fragmenturl_extract_hosturl_extract_parameterurl_extract_pathurl_extract_porturl_extract_protocolurl_extract_query
UUID¶
For more details, see uuid
Window¶
For more details, see window