[
https://issues.apache.org/jira/browse/ASTERIXDB-3128?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vijay Sarathy resolved ASTERIXDB-3128.
--------------------------------------
Resolution: Fixed
> 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
> Assignee: Vijay Sarathy
> Priority: Major
>
> 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)
