Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-1321

In-list to join optimization should have configurable in-list size

          Details

          • Type: Bug
          • Status: Closed
          • Priority: Major
          • Resolution: Fixed
          • Affects Version/s: None
          • Fix Version/s: 1.9.0
          • Component/s: None
          • Labels:
            None

            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);

              Attachments

                Issue Links

                is duplicated by

                Improvement - An improvement or enhancement to an existing feature or task. CALCITE-350 SqlToRelConverter.getInSubqueryThreshold() can it be configurable?

                • Major - Major loss of function.
                • Resolved
                is related to

                Improvement - An improvement or enhancement to an existing feature or task. DRILL-3710 Make the 20 in-list optimization configurable

                • Major - Major loss of function.
                • Closed

                  Activity

                    People

                    • Assignee:
                      gparai Gautam Parai
                      Reporter:
                      gparai Gautam Parai
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      5 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved: