This topic lists information about what functions you can use in Spotfire, for example for writing custom expressions and adding calculated columns, when you work with in-database data tables from Apache Drill. What functions you can use might depend on what database you are connecting to.
The following functions are supported when you are connecting to Apache Drill data sources with the MapR Drill ODBC driver.
Date and Time functions
CURDATE, CURTIME, DAYOFMONTH, DAYOFWEEK, DAYOFYEAR, HOUR, MINUTE, MONTH, NOW, QUARTER, SECOND, WEEK, YEAR
Conditional
COALESCE, NULLIF
Math functions
ABS, ACOS, ASIN, ATAN, CBRT, CEILING, COS, COT, DEGREES, EXP, FLOOR, LOG, LOG10, MOD, PI, POWER, RADIANS, RAND, SIGN, SIN, SQRT, TAN
Operators
+, -, *, /
Statistical functions
AVG, COUNT, MAX, MIN, STDDEV, STDDEV_POP, STDDEV_SAMP, SUM, VAR_POP, VAR_SAMP, VARIANCE
Text functions
CONCAT, LCASE, LOWER, LTRIM, REPLACE, RTRIM, SUBSTRING, UCASE, UPPER
See also:
Accessing Data from Apache Drill and Dremio