Hadoop Hive

The tables listed below describe the MicroStrategy function support for Hadoop Hive databases:

Function type	Functions that can be evaluated on the database
Basic functions	Add Average Avg Count First GeoMean Greatest Last Least Max Min Multiply Stdev StdevP Sum Var VarP
Date and time functions	AddDays CurrentDate CurrentDateTime CurrentTime Date DayOfMonth DaysBetween Hour Minute Month Second Week Year
Internal functions	None
Null and Zero functions	IsNotNull IsNull NullToZero ZeroToNull
OLAP functions	None
Rank and NTile functions	None
String functions	Concat LeftStr Length Lower LTrim Position RightStr RTrim SubStr Trim Upper
Arithmetic operators	- x + / U-
Comparison operators	< <= <> = > >= Begins With Between Contains Ends With In Like Not Begins With Not Between Not Contains Not Ends With Not In Not Like
Comparison operators for rank	<= <> = >= Between NotBetween
Logical operators	AND IF Not Or
Data mining functions	None
Financial functions	None
Mathematical functions	Acos Acosh Asin Asinh Atan Atanh Ceiling Cos Cosh Degrees Exp Floor Ln Log Log10 Mod Power Quotient Radians Round Round2 Sin Sinh Sqrt Tan Tanh
Statistical functions	Covariance Standardize