Supported Vertica functions for case-centric transformations
Not all Vertica functions are enabled for transformations. The functions on this list are enabled for use in transformations for case-centric process mining. For their descriptions, see the Vertica documentation.
The list of enabled functions for object-centric transformations is different. You can find it at Supported functions for object-centric transformations.
ABS
ACOS
ADD_DAYS
ADD_MONTHS
ADD_SECONDS
ANALYZE_STATISTICS
ANALYZE_STATISTICS_PARTITION
ASIN
ATAN
AVG
BTRIM
CAST
CBRT
CEILING
CEIL
CHARACTER_LENGTH
CHARINDEX
CHAR_LENGTH
COALESCE
COLLATION
CONCAT
CONVERT
CORR
COS
COUNT
COPY_TABLE
CURDATE
CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
DATALENGTH
DATE
DATEADD
DATEDIFF
DATEFROMPARTS
DATENAME
DATEPART
DATE_PART
DATE_TRUNC
DAY
DAYOFMONTH
DAYOFWEEK
DAYOFWEEK_ISO
DAYOFYEAR
DAYS
DECODE
DEGREES
DO_TM_TASK
DROP_STATISTICS
EXP
FLOOR
GETDATE
GETUTCDATE
GREATEST
HASH
HEX_TO_BINARY
HOUR
IFNULL
INITCAP
INITCAPB
INSTR
ISDATE
ISNULL
ISNUMERIC
ISUTF8
JDE_TO_TIMESTAMP
LAST_DAY
LEAST
LEFT
LEN
LENGTH
LISTAGG
LN
LOCALTIME
LOCALTIMESTAMP
LOG
LOG10
LOWER
LOWERB
LPAD
LTRIM
MAX
MD5
MIN
MINUTE
MOD
MONTH
MONTHS_BETWEEN
NEXT_DAY
NEW_TIME
NOW
NULLIF
NULLIFZERO
NVL
NVL2
PI
POSITION
POSITIONB
POWER
POW
QUARTER
RADIANS
RANDOM
RANDOMINT
REFRESH
REGEXP_COUNT
REGEXP_LIKE
REGEXP_ILIKE
REGEXP_INSTR
REGEXP_NOT_ILIKE
REGEXP_NOT_LIKE
REGEXP_REPLACE
REGEXP_SUBSTR
REPLACE
REVERSE
RIGHT
ROUND
ROWIDTOCHAR
RTRIM
SECOND
SHA1
SHA224
SHA256
SHA384
SHA512
SIGN
SIN
SLEEP
SPACE
SPLIT_PART
SPLIT_PARTB
SQRT
START_REFRESH
STDDEV_POP
STDDEV_SAMP
STRINGHASH
STRPOS
STRPOSB
SUBSTR
SUBSTRING
SUM
TAN
THROW_ERROR
TIMEOFDAY
TIMESTAMPADD
TIMESTAMPDIFF
TIMESTAMP_ROUND
TIMESTAMP_TRUNC
TIME_SLICE
TO_CHAR
TO_DATE
TO_DAYS
TO_DECIMAL
TO_NUMBER
TO_TIME
TO_TIMESTAMP
TO_TIMESTAMP_TZ
TRANSLATE
TRIM
TRUNC
UPPER
UPPERB
WEEK
WEEK_ISO
YEAR
YEAR_ISO