Skip to Content
author's profile photo Former Member
Former Member

SQL Engine

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 27, 2013 at 01:48 PM

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 27, 2013 at 04:38 AM

    i use a projection as semantics to ouput

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 29, 2013 at 09:25 AM

    Hi

    Which functions are you using for your calculation view?

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

    Regards,

    Jerry

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 13, 2015 at 02:47 PM

    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. "

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.