Supported Vertica functions
Not all Vertica functions are enabled in Data Integration. Below is the list of the enabled functions which could be used in transformations.
To check descriptions of the functions, refer to Vertica's documentation.
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
CUSTOM_BOSCH_SLEEP
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