SapHanaTutorial.Com HOME     Learning-Materials Interview-Q&A Certifications Quiz Online-Courses Forum Jobs Trendz FAQs  
     Explore The World of Hana With Us     
About Us
Contact Us
 Apps
X
HANA App
>>>
Hadoop App
>>>
Tutorial App on SAP HANA
This app is an All-In-One package to provide everything to HANA Lovers.

It contains
1. Courses on SAP HANA - Basics, Modeling and Administration
2. Multiple Quizzes on Overview, Modelling, Architeture, and Administration
3. Most popular articles on SAP HANA
4. Series of Interview questions to brushup your HANA skills
Tutorial App on Hadoop
This app is an All-In-One package to provide everything to Hadoop Lovers.

It contains
1. Courses on Hadoop - Basics and Advanced
2. Multiple Quizzes on Basics, MapReduce and HDFS
3. Most popular articles on Hadoop
4. Series of Interview questions to brushup your skills
Apps
HANA App
Hadoop App
';
Search
Stay Connected
Search Topics
Topic Index
+
-
SQLScript
+
-
Tables in SAP HANA
+
-
Procedure
+
-
Examples of Procedure
SAP HANA CE Functions - Calculation Engine Plan Operators


This article explains what is CE function in HANA and how does it work.
Introduction of CE Functions:

SAP HANA CE functions, which is also known as Calculation Engine Plan Operators (CE operators) are alternatives to SQL statements.
    • CE functions are specially optimized for HANA and can perform better than a normal SQL statement.
    • CE functions are executed in calculation engine.
    • CE functions can also help structure the code in a simpler way.


SAP HANA CE Operators

Types of CE Functions:

There are 2 types of CE functions:

1. Data Source Access operators
It binds a column table or a column view to a table variable.

2. Relational operators
It allows a user to bypass the SQL processor during evaluation and to directly interact with the calculation engine.

Examples of Data Source Access Operators are:
    • CE_COLUMN_TABLE
    • CE_JOIN_VIEW
    • CE_OLAP_VIEW
    • CE_CALC_VIEW

Examples of Relational Operators are:
    • CE_JOIN
    • CE_LEFT_OUTER_JOIN
    • CE_RIGHT_OUTER_JOIN
    • CE_FULL_OUTER_JOIN
    • CE_PROJECTION
    • CE_CALC
    • CE_AGGREGATION
    • CE_UNION_ALL

Never Mix SQL and CE Functions:

Try not to mix up normal SQL and CE functions in a single procedure/scripted calculation view. This will decrease the performance even more.




Support us by sharing this article.



Explore More
Close X
Close X

2 thoughts on “SAP HANA CE Function

  1. Dinesh Sukdeo Godge says:

    Can anyone tell me how to apply exclude condition in CE functions.
    Scenario: if I have vbak table with 500 records and I copied vbak table with same 300 record with table name vbak_ex so I want to see only 200 records from vbak table and want to exclude 300 record by performing ce_join functions.
    Please reply

  2. Hendra says:

    What is the common implementation for this Calculation Engine ?

Leave a Reply

Your email address will not be published. Required fields are marked *

Current day month ye@r *

 © 2017 : saphanatutorial.com, All rights reserved.  Privacy Policy