Vijay Sarathy created ASTERIXDB-3128:
----------------------------------------
Summary: Hints: hashjoin build hint with build still shows warning
Key: ASTERIXDB-3128
URL: https://issues.apache.org/jira/browse/ASTERIXDB-3128
Project: Apache AsterixDB
Issue Type: Bug
Components: COMP - Compiler
Reporter: Vijay Sarathy
To repro ({*}note: this is with CBO turned off{*})
* 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;}}
* set `compiiler.cbo` "false";
* 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",|
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
