The following are the functions that the Hortonworks connector supports.
Supported functions are the functions that you can use when you work with in-database data tables, for example for calculated columns and custom expressions.
Important: Some supported functions might not be possible to use with your database. This depends on what functions are available in the database, which often differs between database versions and types
Date and Time functions
YEAR, QUARTER, MONTH, WEEK, WEEKOFYEAR, DAY, DAYOFMONTH, HOUR, MINUTE, SECOND, DATEDIFF, DATE_ADD
Conversion functions
SN
Math functions
ABS, ACOS, ASIN, ATAN, BIN, CEIL, CEILING, COS, DEGREES, E, EXP, FLOOR, LN, LOG, LOG10, LOG2, NEGATIVE, PI, POW, POWER, POSITIVE, PMOD, RADIANS, RAND, ROUND, SIGN, SIN, SQRT, TAN
Operators
%, -, +, *, /
Statistical functions
SUM, AVG, MIN, MAX, COUNT, UNIQUECOUNT, VARIANCE, VAR_POP, VAR_SAMP, STDDEV_POP, STDDEV_SAMP, CORR, COVAR_POP, COVAR_SAMP, PERCENTILE
Text functions
CONCAT, INSTR, LENGTH, LOWER, LPAD, LTRIM, RPAD, RTRIM, TRIM, UPPER, LOCATE, REPEAT, SPACE, REGEXP_REPLACE, SUBSTR, SUBSTRING, REVERSE, FORMAT_NUMBER
Non-supported functions
Statistical functions:
HISTOGRAM_NUMERIC, COLLECT_SET, COLLECT_LIST
Date and Time functions:
FROM_UNIXTIME, UNIXTIMESTAMP, TO_DATE, DATE_SUB, FROM_UTC_TIMESTAMP, TO_UTC_TIMESTAMP
Text Functions:
ASCII, BASE64, CONTEXT_NGRAMS, CONCAT_WS, DECODE, ENCODE, FIND_IN_SET, GET_JSON_OBJECT, IN_FILE, NGRAMS, PARSE_URL, PRINTF, REGEXP_EXTRACT, SENTENCES, SPLIT, STR_TO_MAP, TRANSLATE, UNBASE64
Collection Functions, Type Conversion Functions, Conditional Functions, Misc. Functions and Table-Generating Functions are not supported in this version of the connector.