SAP HANA SQLScript
SAP HANA SQLScript 中的CE Plan Operators 包括两种：Data Source Acess和Relational Operators。其中Data Source Acess包括CE_COLUMN_TABLE、CE_JOIN_VIEW、CE_OLAP_VIEW、CE_CALC_VIEW;> CE_PROJECTION语法：
view plaincopyprint?
[*]CE_PROJECTION (:var_table, , ...],)
CE_PROJECTION (:var_table, , ...],)
例子:：
view plaincopyprint?
[*]ot_books1 = CE_PROJECTION (:it_books,["TITLE","PRICE","CRCY" AS "CURRENCY"], '"PRICE" > 50');
ot_books1 = CE_PROJECTION (:it_books,["TITLE","PRICE","CRCY" AS "CURRENCY"], '"PRICE" > 50');
相当于：
view plaincopyprint?
[*]ot_books2= SELECT title, price, crcy AS currency FROM :it_books WHERE price > 50;
ot_books2= SELECT>
view plaincopyprint?
[*]
view plaincopyprint?
[*]
解释：
用于限制变量表的列的输出，可以选择性的重命名，计算表达式或者包含过滤器。
CE_CALC
语法：
view plaincopyprint?
[*]CE_CALC('expr', )
CE_CALC('expr', )
例子：
view plaincopyprint?
[*]with_tax = CE_PROJECTION(:product, ["CID", "CNAME", "OID", "SALES",
with_tax = CE_PROJECTION(:product, ["CID", "CNAME", "OID", "SALES",
view plaincopyprint?
[*] CE_CALC('"SALES" * :vat_rate',decimal(10,2)) AS "SALES_VAT"],
[*] '"CNAME" = '':cname''');
CE_CALC('"SALES" * :vat_rate',decimal(10,2)) AS "SALES_VAT"],
'"CNAME" = '':cname''');
相当于：
view plaincopyprint?
[*]with_tax2 = select CID, CNAME, OID, SALES, (SALES * :vat_rate) as SALES_VAT from :product where CNAME = ':name';
with_tax2 = select CID, CNAME, OID, SALES, (SALES * :vat_rate) as SALES_VAT from :product where CNAME = ':name';
解释：
主要用于其他运算中，请注意例子中的参数的表现形式。
CE_AGGREGATION
语法：
view plaincopyprint?
[*]CE_AGGREGATE(:var_table, ], ["column", ...])
CE_AGGREGATE(:var_table, ], ["column", ...])
例子：
view plaincopyprint?
[*]ot_books1 = CE_AGGREGATION (:it_books,, ["YEAR"]);
ot_books1 = CE_AGGREGATION (:it_books,, ["YEAR"]);
相当于：
view plaincopyprint?
[*]ot_books2 = SELECT COUNT (publisher) AS cnt, year FROM :it_books GROUP BY year;
ot_books2 = SELECT COUNT (publisher) AS cnt, year FROM :it_books GROUP BY year;
解释：
用于聚合运算。
页:
[1]