You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Ulrich Kramer (Jira)" <ji...@apache.org> on 2021/06/07 11:59:00 UTC

[jira] [Created] (CALCITE-4640) Propagate table scan hints to JDBC

Ulrich Kramer created CALCITE-4640:
--------------------------------------

             Summary: Propagate table scan hints to JDBC
                 Key: CALCITE-4640
                 URL: https://issues.apache.org/jira/browse/CALCITE-4640
             Project: Calcite
          Issue Type: Improvement
          Components: core
    Affects Versions: 1.27.0
            Reporter: Ulrich Kramer
             Fix For: next


We would like to use table scan hints to pass [parameters and variables to HANA views|https://help.sap.com/viewer/88fe5f56472e40cca6ef3c3dcab4855b/2.0.04/en-US/fafb3ea432e54fca9eff11648df5bccd.html].

It should be possible to convert the following Calcite SQL
{code}
SELECT * FROM VIEW /*+ PLACEHOLDERS("$$PARAMETER_1$$"='Test') */
{code}
using a special {{SqlDialect}} to a HANA specific statement
{code}
SELECT * FROM VIEW ('PLACEHOLDER' = ('$$PARAMETER_1$$', 'Test'))
{code}
See also my [mail in the mailing list|https://mail-archives.apache.org/mod_mbox/calcite-dev/202105.mbox/%3CD161B82F-5DEC-49A2-A873-4817F4DEB15F%40contoso.com%3E].



--
This message was sent by Atlassian Jira
(v8.3.4#803005)