Error while executing CE function calculation view

[former_member226419]

Hi,

I am getting below error while executing an query below.

Can someone please help?

Query:

BEGIN

select1 = CE_COLUMN_TABLE ("ZTEST_SUMEET","TEST1", [NAME,AMOUNT]);

select2 = CE_COLUMN_TABLE ("ZTEST_SUMEET","TEST2", [NAME,AMOUNT]);

var_out = CE_UNION_ALL (:select1, :select2);

END

Error:

Message :

                Internal deployment of object failed;Repository: Encountered an error in repository runtime extension;Internal Error:Deploy Calculation View: SQL: sql syntax error: incorrect syntax near "TEST1": line 5 col 43 (at pos 239)nSet Schema DDL statement: set schema "SYSTEM"nType DDL: create type "_SYS_BIC"."ztest_sumeet/ZTEST/proc/tabletype/VAR_OUT" as table ("name" VARCHAR(6), "amount" DECIMAL(5,1))nProcedure DDL: create procedure "_SYS_BIC"."ztest_sumeet/ZTEST/proc" ( OUT var_out "_SYS_BIC"."ztest_sumeet/ZTEST/proc/tabletype/VAR_OUT" ) language sqlscript sql security definer reads sql data as  nn BEGIN n nselect1 = CE_COLUMN_TABLE ("ZTEST_SUMEET","TEST1", [NAME,AMOUNT]);nselect2 = CE_COLUMN_TABLE ("ZTEST_SUMEET","TEST2", [NAME,AMOUNT]);nvar_out = CE_UNION_ALL (:select1, :select2);nnEND nn

BR

Sumeet

[Former Member · Accepted solution]

First, don't use CE functions, use SQL. They are slower these days.

Second - simple syntax error, check this guide: http://help.sap.com/openSAP/HANA1/openSAP_HANA1_Week_03_Unit_03_Procedure_CE_Functions_Presentation....

You have specified two table names instead of one in CE_COLUMN_TABLE

[former_member226419 · Accepted solution]

Hi,

Actually "ZTESWT_SUMEET" is a schema and TEST1 is a table name.

BR

Sumeet

[Former Member · Accepted solution]

"ZTEST_SUMEET"."TEST1"

Would be the correct syntax.

[former_member226419 · Accepted solution]

Hi,

Thanks a lot it is solved.

BR

Sumeet