Details
-
Bug
-
Resolution: Fixed
-
Major
-
7.2.0
-
7.2.0-5230
-
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
- links to