[CALCITE-1321] In-list to join optimization should have configurable in-list size

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.9.0
• Assignee: Gautam Parai
• Reporter: Gautam Parai
• Created: 20/Jul/16 00:59
• Updated: 27/Feb/24 22:23
• Resolved: 27/Jul/16 07:31

Description

We current have a default in-list size of 20. Instead of the magic number 20, we should make this configurable.

select count(*) from table where col in (1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1);

Issue Links

• is duplicated by: CALCITE-350 SqlToRelConverter.getInSubqueryThreshold() can it be configurable?
• is related to: DRILL-3710 Make the 20 in-list optimization configurable