SQL Engine

[Former Member]

As we know, when we create a view, we can use SQL Engine to excute it. I want to know the bellow quesions

1. what is the SQL Engine?

2. what the different operation hana will do when we choose sql engine or not?

3. If we do a projection which includes a VARCHAR field and we use SQL Engine, we can activate it but when we do data preview , the error 266 inconsistent data type: VARCHAR or NCLOB are invalid function argument types.

Thanks,

Hao

[Former Member · Accepted solution]

参考这个吧，看起来这个比较全面   http://scn.sap.com/message/13968227

[Former Member · Accepted solution]

这个确实很全，但是没有calculate view 里面sql engine的作用。还是没有解决我的问题。

[Former Member]

Hello,

it is quiet an old thread but in regards to the developer guide you can find following information:

"When this property is set to SQL Engine, the calculation engine generates SQL code for each node at runtime and combines them into one big SQL statement which is then passed to the SQL interface. This might be beneficial since the SQL interface also involves standard SQL optimizer which implements a lot more optimization rules than the Calculation Engine. For example, the most important rule is join ordering determination.

This option is only efficient if every node is translated so that one big SQL statement can be generated. "

[Former Member]

Hi

Which functions are you using for your calculation view?

Usually, SQL engine is sql function and sql statment and so on.

Regards,

Jerry

[Former Member]

i use a projection as semantics to ouput