Supported functions

List of detected functions from different workloads migrated in the SMA and their functional equivalence.

Strings

Function
Status

CONCAT

SUPPORTED

LEFT

SUPPORTED

LOWER

SUPPORTED

SPLIT

SUPPORTED

SUBSTRING

SUPPORTED

SUBSTRING_INDEX

PENDING

TRIM

SUPPORTED

UPPER

SUPPORTED

Numerics

Function
Status

COUNT

SUPPORTED

LAST

PENDING

MAX

SUPPORTED

MIN

SUPPORTED

ROUND

SUPPORTED

SUM

SUPPORTED

Date

Function
Status

CURRENT_DATE

SUPPORTED

CURRENT_TIMESTAMP

SUPPORTED

DATEDIFF

PENDING

DATE_SUB

PENDING

DAY

SUPPORTED

FIRST_VALUE

PENDING

FROM_UNIXTIME

PENDING

TO_DATE

SUPPORTED

WEEKOFYEAR

SUPPORTED

Advanced functions

Function
Status

COALESCE

SUPPORTED

EXPLODE

PENDING

IFNULL

SUPPORTERD

MERGE

PENDING

POSEXPLODE

PENDING

ROW_NUMBER

SUPPORTED

Last updated

#332: [SIT-1562] SQL Readiness

Change request updated