Calculated functions

This page links to all of the calculated functions available in Upsolver.

Aerospike functions

• AEROSPIKE_KV

Array functions

• ARRAY_MAX

• ARRAY_MIN

• ARRAY_SUM

• CONCAT

• COUNT_VALUES

• COUNT_VALUES_IF

• DISTINCT_VALUES

• ELEMENT_AT

• FIRST_ELEMENT

• LAST_ELEMENT

• LEAST

Conditional functions

• COALESCE
• IF_ELSE
• NULL_IF

Date functions

• ADD_TIME_ZONE_OFFSET
• BETWEEN
• DATE_FORMAT
• PARSE_DATE
• TO_UNIX_EPOCH_MILLIS
• TO_UNIX_EPOCH_SECONDS
• UNIX_EPOCH_TO_DATE

External API functions

• GEO_IP
• USER_AGENT_PARSER
• WURFL_USER_AGENT

Filter functions

• AND
• BETWEEN
• CONTAINS
• EQUAL_TO
• EXISTS
• GREATER_THAN
• GREATER_THAN_OR_EQUAL_TO
• IN_SET
• IS_DUPLICATE
• LESS_THAN
• LESS_THAN_OR_EQUAL_TO
• NOT
• NOT_EQUAL_TO
• OR
• RANDOM
• XOR

Numeric functions

• ABS
• ADD
• CEILING
• COS
• DEGREES
• DIVIDE
• EXP
• FLOOR
• GET_PROCESSING_TIME
• GREATEST
• INTEGER_DIVIDE
• LN
• LOG
• MOD
• MULTIPLY
• NEGATE
• POWER
• RADIANS
• RECIPROCAL
• ROUND
• SIGN
• SIN
• SQRT
• SQUARE
• SUBTRACT
• TAN
• TAN_H
• TRUNC

Spatial functions

• WKT_SPATIAL_CONTAINS
• WKT_SPATIAL_INTERSECT

String functions

• BASE64_DECODE
• BYTES_SUBSTRING
• JOIN_ARRAYS
• MD5
• REGEX
• REGEX_MATCH_POSITION
• REGEX_NAMED_GROUPS
• REPLACE
• SHA1
• SHA256
• SPLIT
• SPLIT_TO_RECORD
• STRING_FORMAT
• STRING_LENGTH
• STRIP_MARGIN
• STRIP_PREFIX
• STRIP_SUFFIX
• SUBSTRING
• TOP_PRIVATE_DOMAIN
• TO_LOWER
• TO_UPPER
• TRANSLATE
• TRIM
• TRIM_CHARS
• URL_DECODE
• URL_ENCODE
• URL_PARSER
• UUID_GENERATOR

Structural functions

• FROM_KEY_VALUE
• GET_RANGE
• ITEM_INDEX
• JSON_PATH
• JSON_TO_RECORD
• MAP_WITH_INDEX
• QUERY_STRING_TO_RECORD
• TO_ARRAY
• ZIP

Type conversion functions

• HEX_TO_DECIMAL
• TO_DOUBLE
• TO_FLOAT
• TO_INT
• TO_LONG
• TO_NUMBER
• TO_STRING