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:
get the contents of a table
get attribute view contents
procedure to get analytical view contents
get calculation view contents
inner join of two tables
left outer join
right outer join
union for two tables, identical tuples won’t be dropped
apply a filter, compute expressions, rename column.
calculate an expression into a new column
aggregation of the data to a group of attributes.
Supported aggregation functions: count, sum, min, max, average = sum/count
concatenation of columns of two input tables, no counterpart in SQL
unit conversion of input table, no counterpart in SQL
In the following table, you can find comparison of SQL and CE Functions