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

Optimize MIN aggregate without group by

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 5.5.0
    • 5.5.0
    • secondary-index
    • Triaged
    • Unknown

    Description

      For MIN aggregate without group by, N1QL sends Limit 1 queries in API2 e.g. if the aggregate is on the first column or aggregate on second column but first column has equality.

      With API3, this optimization is no longer available.

      Either:
      1. Indexer can have the extra logic to determine when such optimizations can be applied
      2. N1QL can call API2 in such cases with LIMIT 1 or API3 without pushing down group aggr.

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          deepkaran.salooja Deepkaran Salooja created issue -
          deepkaran.salooja Deepkaran Salooja made changes -
          Field Original Value New Value
          Component/s query [ 10718 ]
          deepkaran.salooja Deepkaran Salooja made changes -
          Triage Untriaged [ 10351 ] Triaged [ 10350 ]
          Sitaram.Vemulapalli Sitaram Vemulapalli made changes -
          Component/s query [ 10718 ]
          Sitaram.Vemulapalli Sitaram Vemulapalli made changes -
          Labels query
          jeelan.poola Jeelan Poola made changes -
          Assignee Deepkaran Salooja [ deepkaran.salooja ] Prathibha Bisarahalli [ prathibha ]
          prathibha Prathibha Bisarahalli (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Resolved [ 5 ]
          arunkumar Arunkumar Senthilnathan (Inactive) made changes -
          Assignee Prathibha Bisarahalli [ prathibha ] Korrigan Clark [ korrigan.clark ]
          deepkaran.salooja Deepkaran Salooja made changes -
          Status Resolved [ 5 ] Closed [ 6 ]

          People

            korrigan.clark Korrigan Clark (Inactive)
            deepkaran.salooja Deepkaran Salooja
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty