HINTS in SELECT Statement - Technical User

[Naga_P]

Hi... We are using a SELECT statement with a Placeholder and "WITH HINT (NO_CS_JOIN".... the statement runs successfully with one dialog user.... we have a technical user, to provision Calc View data into a downstream datamart... and the same Select statement with the Tech User is not working...Do we need to use a different syntax to apply hints when executing SELECT statements with a Technical User !t

[pfefferf]

What error message do you get?

[simon25]

Hi Naga,

Generally your query with a hint applied should look something like this.

<sql_statement> WITH HINT (NO_CS_JOIN)

You haven't provided the example statement + hint , so I cannot see where the syntax could be wrong, but you certainly don't need inverted commas "" around the WITH HINT clause.

Hints are applied differently depending on what object you are querying such as SQL or CDS views for example.

As explained in SAP KBA 2939423 - Getting Error while creating View with HINT - incorrect syntax near "HINT"

Please take a look at our FAQs on Hints in SAP HANA :

2142945 - FAQ: SAP HANA Hints

'2. Which types of hints exist?'

'3. How can hints be specified?'

2400006 - FAQ: SAP HANA Statement Hints

The Admin guide provides examples also :HINT Details

Kind Regards

Simon