SAP HANA CE Functions List

Inside the SQL Script, SQL language and also highly optimized, equivalent Calculation Engine functions (CE Functions) can be used. CE functions are preferred to standard SQL firstly because they are a lot easier to work with, secondly because their use can be parallelized by the SAP HANA server.

In the following table you can find list of CE functions:

Function
Description
CE_COLUMN_TABLE
get the contents of a table
CE_JOIN_VIEW
get attribute view contents
CE_OLAP_VIEW
procedure to get analytical view contents
CE_CALC_VIEW
get calculation view contents
CE_JOIN
inner join of two tables
CE_LEFT_OUTER_JOIN
left outer join
CE_RIGHT_OUTER_JOIN
right outer join
CE_UNION_ALL
union for two tables, identical tuples won’t be dropped
CE_PROJECTION
apply a filter, compute expressions, rename column.
CE_CALC
calculate an expression into a new column
CE_AGGREGATION
aggregation of the data to a group of attributes.
Supported aggregation functions: count, sum, min, max, average = sum/count
CE_VERTICAL_UNION
concatenation of columns of two input tables, no counterpart in SQL
CE_CONVERSION
unit conversion of input table, no counterpart in SQL

 

In the following table, you can find comparison of SQL and CE Functions

SAP HANA - SQL vs CE Build in Functions

Leave a Comment