Date and Time functions
YEAR, QUARTER, MONTH, MONTHNAME, WEEK, DAYOFWEEK, DAYOFYEAR, DAYOFMONTH, DAYNAME, HOUR, MINUTE, SECOND, MILLISECOND, NOW, ADD_DAYS, ADD_MONTHS, ADD_SECONDS, ADD_YEARS, ISOWEEK, NEXT_DAY, LAST_DAY, YEARS_BETWEEN, MONTHS_BETWEEN, DAYS_BETWEEN, SECONDS_BETWEEN, LOCALTOUTC, UTCTOLOCAL
Conversion functions
SN
Operators
%, -, +, *, /
Text functions
ASCII, CHAR, CONCAT, LCASE, UCASE, LOWER, UPPER, LEFT, RIGHT, LENGTH, LOCATE, LPAD, RPAD, TRIM, LTRIM, RTRIM, NCHAR, REPLACE, SUBSTR_AFTER, SUBSTR_BEFORE, SUBSTRING, UNICODE
Statistical functions
SUM, AVG, MIN, MAX, COUNT, UNIQUECOUNT
Statistical functions only available for relational data:
MEDIAN, STDDEV, STDDEV_POP, STDDEV_SAMP, VAR, VAR_POP, VAR_SAMP
Math functions
Note: Math functions are only available for relational SAP HANA data, and cannot be used for information views data.
ABS, ACOS, ASIN, ATAN, ATAN2, BITAND, BITCOUNT, CEIL, COS, COSH, COT, EXP , FLOOR, LN, LOG, MOD, POWER, ROUND, SIGN, SIN, SINH, SQRT, TAN, TANH, UMINUS
Non-supported functions
Math functions:
GREATEST, LEAST, HEXTOBIN, BINTOHEX.
Date and Time functions:
CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, CURRENT_UTCDATE, CURRENT_UTCTIME, CURRENT_UTCTIMESTAMP, EXTRACT
Binning is not supported by this connector.