[
https://issues.apache.org/jira/browse/CALCITE-5224?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17573506#comment-17573506
]
Benchao Li commented on CALCITE-5224:
-------------------------------------
Currently, there are three ways to config Calcite:
* jdbc connection params, you can find all the definitions in
{{CalciteConnectionProperty}}
* java system properties, you can find all the definitions in
{{CalciteSystemProperty}}
* config objects in {{{}SqlParser.Config{}}}, {{{}SqlValidator.Config{}}},
{{{}SqlToRelConverter.Config{}}}, they can be configured via {{FrameworkConfig}}
However, these three ways are not consistent now. For instance,
{{SqlToRelConverter.Config#withInSubQueryThreshold}} cannot be configured in
jdbc connection params and system properties.
{{SQL2REL_CONFIG_HOOK}} is just a test util to eliminate the gap between #1/#2
and #3.
> 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)
