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

Hints: hashjoin build hint with build still shows warning

    XMLWordPrintable

Details

    • Untriaged
    • 0
    • Unknown
    • Analytics CBO Sprint 15, Analytics CBO Sprint 16

    Description

      To repro (note: no CBO involved)

      • CREATE Dataset:
        • CREATE DATASET IF NOT EXISTS route ON `travel-sample`.inventory.route;
        • CREATE DATASET IF NOT EXISTS airport ON `travel-sample`.inventory.airport
      • \set -max-warnings 1;
      • Run query: explain SELECT COUNT(DISTINCT r.destinationairport) FROM airport a JOIN route r ON r.sourceairport /*+ hashjoin build(r) */ = a.faa WHERE a.city = 'San Francisco' AND a.country = 'United States'

      We see warning below:

      	} ]
      	,
      	"plans":{},
      	"warnings": [{ 
      		"code": 24073,		"msg": "Could not apply hash join hint: build with r (in line 1, at column 125)"
      	],
      	"status": "success", 

      Attachments

        Issue Links

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

          Activity

            People

              pierre.regazzoni Pierre Regazzoni
              pierre.regazzoni Pierre Regazzoni
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty