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

Disable DISTINCT pushdown for Joins/NEST/UNNEST

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.0.0
    • Fix Version/s: 5.0.0
    • Component/s: query
    • Labels:
      None
    • Triage:
      Untriaged
    • Is this a Regression?:
      Unknown

      Description

      Don't push the distinct to indexer.

      CREATE INDEX ix1 ON default(docid);
      SELECT DISTINCT docid FROM default b1 JOIN default b2 ON KEYS b1.docid WHERE docid = "abc";
      

        Attachments

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

          Activity

          Hide
          gerald Gerald Sangudi (Inactive) added a comment -

          Also consider NEST and UNNEST.

          Show
          gerald Gerald Sangudi (Inactive) added a comment - Also consider NEST and UNNEST.
          Show
          Sitaram.Vemulapalli Sitaram Vemulapalli added a comment - http://review.couchbase.org/#/c/74485/
          Hide
          build-team Couchbase Build Team added a comment -

          Build 5.0.0-2160 contains query commit 8cda37546aded77ed0abd03dfa4efebd60c6cc44 with commit message:
          MB-23097 Disable DISTINCT pushdown for Joins
          https://github.com/couchbase/query/commit/8cda37546aded77ed0abd03dfa4efebd60c6cc44

          Show
          build-team Couchbase Build Team added a comment - Build 5.0.0-2160 contains query commit 8cda37546aded77ed0abd03dfa4efebd60c6cc44 with commit message: MB-23097 Disable DISTINCT pushdown for Joins https://github.com/couchbase/query/commit/8cda37546aded77ed0abd03dfa4efebd60c6cc44
          Hide
          Prerna.Manaktala Prerna Manaktala (Inactive) added a comment -

          Sitaram Vemulapalli:

          Is the query:
          SELECT DISTINCT b1.docid FROM default b1 JOIN default b2 ON KEYS b1.docid WHERE b1.docid = "abc";

          Show
          Prerna.Manaktala Prerna Manaktala (Inactive) added a comment - Sitaram Vemulapalli : Is the query: SELECT DISTINCT b1.docid FROM default b1 JOIN default b2 ON KEYS b1.docid WHERE b1.docid = "abc";

            People

            • Assignee:
              Prerna.Manaktala Prerna Manaktala (Inactive)
              Reporter:
              Sitaram.Vemulapalli Sitaram Vemulapalli
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Gerrit Reviews

                There are no open Gerrit changes

                  PagerDuty

                  Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.