Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-14721

Calcite. SOME with subquery consume huge time.

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • None
    • sql

    Description

      Table of 7 rows and further request :

      SELECT name FROM Orders o WHERE name <= SOME (SELECT name FROM Orders o)

      consume 1 min 21 sec for now.

      Attachments

        Issue Links

          is fixed by

          Improvement - An improvement or enhancement to an existing feature or task. IGNITE-15203 Calcite. Extract Filter and Project related rules to separate HEP phase

          • Major - Major loss of function.
          • Resolved
          is part of

          New Feature - A new feature of the product, which has yet to be developed. IGNITE-12248 Apache Calcite based query execution engine

          • Major - Major loss of function.
          • Open

          Activity

            People

              Unassigned Unassigned
              zstan Evgeny Stanilovsky
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: