SAP HANA Connector > SAP HANA SQL ELT optimization > SQL ELT optimization supported operations, functions, operators, and transformations
  

SQL ELT optimization supported operations, functions, operators, and transformations

The following table lists the supported operations:
Operation
SQL ELT optimization
Read
Yes
Write
Only the Insert operation is supported.
The following table summarizes the availability of functions that you can push to an SAP HANA database using full or source SQL ELT optimization.
Function
Function
Function
ABS()
INSTR()
SQRT()
AVG()
ISNULL()
STDDEV()
CHR()
LOG()
SUM()
CONCAT()
LOOKUP()
SYSDATE()
COS()
LOWER()
SYSTIMESTAMP()
COUNT()
MAX()
TAN()
DATE_COMPARE()
MIN()
TO_BIGINT
DATE_DIFF()
POWER()
TO_DECIMAL()
DATE_GET_PART()
ROUND()
TO_FLOAT()
DECODE()
SIN()
TO_INTEGER()
EXP()
SINH()
TRUNC()
IIF()
SOUNDEX()
UPPER()
-
-
VARIANCE()
The following table lists the 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 SQL ELT optimization.
Operator
+
-
*
/
%
||
>
<
=
>=
<=
!=
AND
OR
NOT
The following table lists the transformations that you can push to SAP HANA:
Transformations
Aggregator
Expression
Filter
Joiner
Lookup
Router
Sorter
Union