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
Leave a Reply
Want to join the discussion?Feel free to contribute!