[
https://issues.apache.org/jira/browse/CALCITE-5224?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17573454#comment-17573454
]
Joseph Eid edited comment on CALCITE-5224 at 7/31/22 6:14 PM:
--------------------------------------------------------------
Hello [~jingzhang], first of all thanks for the quick response!
-When executing a query with, the {{Prepare}} (impl) class calls this method
with the default value just before creating a {{SqlToRelConverter}} object see
{{{}prepareSql{}}}.-
-So in different words, how could I set the in subquery threshold when
executing queries via JDBC?-
* -Is there for instance a way to let Calcite use my own customised Prepare
implementation and/or SqlToRelConverter instead of the default one? and how?-
Found the SQL2REL_CONFIG_HOOK :D Thanks again!
was (Author: JIRAUSER293689):
Hello [~jingzhang], first of all thanks for the quick response!
When executing a query with, the {{Prepare}} (impl) class calls this method
with the default value just before creating a {{SqlToRelConverter}} object see
{{{}prepareSql{}}}.
So in different words, how could I set the in subquery threshold when executing
queries via JDBC?
* Is there for instance a way to let Calcite use my own customised Prepare
implementation and/or SqlToRelConverter instead of the default one? and how?
> Allow configuring IN-subquery threshold
> ---------------------------------------
>
> Key: CALCITE-5224
> URL: https://issues.apache.org/jira/browse/CALCITE-5224
> Project: Calcite
> Issue Type: Wish
> Components: core
> Reporter: Joseph Eid
> Priority: Critical
> Attachments: image-2022-07-31-22-50-14-721.png
>
>
> Currently, {{SqlToRelConverter}} instances always use a config with
> hard-coded threshold of 20.
> I can't find any parameters (or a way) to change that as it happens very
> early when preparing the SQL statement.
> Would be great to make this configurable from the outside.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
