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

Sql. Push down predicate under correlate

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 3.0
    • sql

    Description

      Currently, predicate doesn't pushed down under LogicalCorrelate node. As a result, complex queries with multiple joins, such q2, q4, q21, q22 from TPC-H suite, executed as a humongous cross join of several tables with post filtration afterwards.

      This could simply be addressed by introducing CoreRules.FILTER_CORRELATE to rule set.

      Attachments

        Issue Links

        causes

        Bug - A problem which impairs or prevents the functions of the product. IGNITE-20880 Some TPC-H queries hang

        • Major - Major loss of function.
        • Resolved
        links to

        Web Link GitHub Pull Request #3049

        Activity
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            korlov Konstantin Orlov
            korlov Konstantin Orlov
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 20m
                20m

                Slack

                  Issue deployment