Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-55122

[CX] Long query compilation due to pushing down assign operators unnecessarily

    XMLWordPrintable

Details

    • Untriaged
    • 0
    • Unknown
    • Analytics Sprint 12

    Description

      One of the things that PushFieldAccessRule attempts to do is push an assign operator down as close as possible to the respective data scan operator. In the case where all the operators below the assign are other assign operators, pushing down the assign is not necessary since it's already close to the data scan operator. Pushing assign operators down blindly was shown to be problematic when the SELECT statement has a large number of fields causing the compilation of the query to take eternity.

      Attachments

        Issue Links

          Activity

            People

              chanabasappa.ghali Chanabasappa Ghali
              ali.alsuliman Ali Alsuliman
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                PagerDuty