[
https://issues.apache.org/jira/browse/ASTERIXDB-3128?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17698641#comment-17698641
]
Vijay Sarathy commented on ASTERIXDB-3128:
------------------------------------------
Checked the variables used from data scan operators that are descendants of the
join to find the hinted collection if it is not found in the immediate children
due to projections.
> 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)
