Hyperstage Optimizer Supported Functions and Operators

COALESCE

YES

CASE

YES

COALESCE

TBD

NULLIF

YES

BIT_LENGTH

YES

CONCAT

YES

LEFT

YES

LENGTH

YES

LOCATE

YES

LOWER

YES

LPAD

YES

LTRIM

YES

OCTET_LENGTH

YES

POSITION

YES

RIGHT

YES

RPAD

YES

RTRIM

YES

SUBSTR

YES

TRIM

YES

TRUNC

TBD

UPPER

YES

Modulo ( % )

YES

ABS

YES

ACOS

YES

ASIN

YES

ATAN2, ATAN

YES

ATAN

YES

CEIL

YES

COS

YES

COT

YES

DEGREES

YES

EXP

YES

FLOOR

YES

LN

YES

LOG

YES

MOD

YES

PI

YES

POWER

YES

RADIANS

YES

RANDOM

TBD

SIGN

YES

SIN

YES

SQRT

YES

TAN

YES

CURRENT_DATE

YES

CURRENT_TIME

YES

DATE

YES

DAY

YES

DAYOFYEAR

YES

FROM_UNIXTIME

YES

HOUR

YES

MINUTE

YES

MONTH

YES

NOW

YES

QUARTER

YES

SECOND

YES

TIME

YES

YEAR

No

CAST

YES

MD5

TBD

AVG

YES

BIT_OR

No

BIT_AND

No

COUNT(DISTINCT)

TBD

COUNT

YES

MIN

YES

MAX

YES

STD, STDDEV

YES

STDDEV_POP

YES

STDDEV_SAMP

YES

SUM

YES

VAR_POP

YES

VAR_SAMP

YES

VARIANCE

YES