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
