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