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