SAP HANA Connector

SAP HANA Connector

Pushdown optimization supported operations, functions, operators, and transformations

Pushdown optimization supported operations, functions, operators, and transformations

The following table lists the supported operations:
Operation
Pushdown
Read
Yes
Write
Only the Insert operation is supported.
The following table summarizes the availability of pushdown functions in an SAP HANA database. Columns marked with an X indicate that the function can be pushed to the SAP HANA database by using full or source pushdown optimization. Columns marked with a dash (-) symbol indicate that the function cannot be pushed to the database.
Function
Pushdown
Function
Pushdown
Function
Pushdown
ABS()
X
INSTR()
X
SQRT()
X
AVG()
X
ISNULL()
X
STDDEV()
X
CHR()
X
LEAST()
-
SUM()
X
CONCAT()
X
LOG()
X
SYSDATE()
X
COS()
X
LOOKUP()
X
SYSTIMESTAMP()
X
COUNT()
X
LOWER()
X
TAN()
X
DATE_COMPARE()
X
MAX()
X
TO_BIGINT
X
DATE_DIFF()
X
MIN()
X
TO_DECIMAL()
X
DATE_GET_PART()
X
POWER()
X
TO_FLOAT()
X
DECODE()
X
ROUND()
X
TO_INTEGER()
X
EXP()
X
SIN()
X
TRUNC()
X
GREATEST()
-
SINH()
X
UPPER()
X
IIF()
X
SOUNDEX()
X
VARIANCE()
X
The following table lists the pushdown operators that can be used in an SAP HANA database. Columns marked with an X indicate that the operator can be pushed to the SAP HANA database by using full pushdown optimization.
Operator
Pushdown
+
X
-
X
*
X
/
X
%
X
||
X
>
X
<
X
=
X
>=
X
<=
X
!=
X
AND
X
OR
X
NOT
X
^=
-
The following table lists the transformation logic that is supported by pushdown optimization:
Transformations
Pushdown
Aggregator
X
Expression
X
Filter
X
Joiner
X
Lookup
X
Router
X
Sorter
X
Union
X