Supported Functions


Date and Time functions

Year, Quarter, Month, Week, DayOfMonth, DayOfYear, DayOfWeek, Hour, Minute, Second, CurDate, CurTime, DayName, FormatDate, FormatTime, FormatTimestamp, ModifyTimeZone, MonthName, ParseDate, ParseTime, ParseTimestamp, TimestampCreate

Math functions

Degrees, Abs, Mod, Pi, Radians, Rand, ACos, ASin, Cos, Cot, Sin, Tan, Ceiling, Exp, Floor, Log10, Log, Power, Round, Sign, Sqrt, ATan, ATan2

Operators

 +, -, *, /

Statistical functions

Sum, Avg, Min, Max, Count, UniqueCount, Stddev_pop, Stddev_samp, Var_pop, Var_samp

Text functions

Concat, Concat2, Initcap, Length, Lcase, Lpad, Ltrim, Rtrim, Rpad, Repeat, Replace, Trim, Ucase, Ascii, Chr, Left, Right, Substring, Translate, Convert, EndsWith, Insert, Locate, Space, Unescape

 

Binning is not supported by this connector.

 

AI-SQL functions

Note: The AI-SQL functions are not supported as functions in calculated columns, custom expressions or other Spotfire interfaces. However, they can be used in custom queries, see Using an AI-SQL function in a Custom Query.

ADVANCEDSEARCH, ENDSWITH, ENTITY, EQUALS, FULLTEXTSEARCH, FUZZY, NEAR, ONEAR, REGEX,SIMPLESEARCH, STARTSWITH, TERM, AIESCORE

If you are logged in to Attivio DSD, you can read more about the different AI-SQL functions at https:/answers.attivio.com.

See also:

Attivio (Teiid) Data Types

Details on Attivio Connection