skip to main content
Supported scalar functions : Scalar function support for Apache Hive
 

Try DataDirect Cloud Now

Scalar function support for Apache Hive

The table identifies the scalar functions that DataDirect Cloud supports for Apache Hive.
Applications connecting through JDBC or ODBC can use the following scalar functions in expressions. For syntax details, consult your JDBC or ODBC documentation.
Table 24. Scalar Functions
String Functions
Numeric Functions
Timedate Functions
System Functions
ASCII
ABS
CURDATE
DATABASE
CONCAT
ACOS
CURTIME
IFNULL
INSERT
ASIN
DAYOFMONTH
LCASE
ATAN
HOUR
LEFT
CEILING
MINUTE
LENGTH
COS
MONTH
LOCATE
COT
NOW
LOCATE_2
DEGREES
QUARTER
LTRIM
EXP
SECOND
REPEAT
FLOOR
TIMESTAMPADD
REPLACE
LOG
TIMESTAMPDIFF
RIGHT
LOG10
WEEK
RTRIM
MOD
YEAR
SPACE
PI
SUBSTRING
POWER
UCASE
RADIANS
RAND
ROUND
SIGN
SIN
SQRT
TAN