What is CE_COLUMN_TABLE operator in SAP HANA ?

CE_COLUMN_TABLE operator provides access to an existing column table. It takes the name of the table and returns its content bound to a variable.

Example:

ot_books1 = CE_COLUMN_TABLE (“BOOKS�);

ot_books2 = CE_COLUMN_TABLE (“BOOKS�, [“TITLE�, “PRICE�, “CRCY�]);

This example only works on a column table and does not invoke the SQL processor. It is semantically equivalent to the following:

ot_books3 = SELECT * FROM books;

ot_books4 = SELECT title, price, crcy FROM books;

The function that provide data source access does not allow renaming of attributes.