[CALCITE-4640] Propagate table scan hints to JDBC

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.27.0
• Fix Version/s: 1.28.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Ulrich Kramer
• Created: 07/Jun/21 11:58
• Updated: 06/Oct/22 10:05
• Resolved: 07/Jul/21 11:00

Description

We would like to use table scan hints to pass parameters and variables to HANA views.

It should be possible to convert the following Calcite SQL

SELECT * FROM VIEW /*+ PLACEHOLDERS("$$PARAMETER_1$$"='Test') */

using a special SqlDialect to a HANA specific statement

SELECT * FROM VIEW ('PLACEHOLDER' = ('$$PARAMETER_1$$', 'Test'))

See also my mail in the mailing list.

Issue Links

• links to: GitHub Pull Request #2426