[
https://issues.apache.org/jira/browse/ASTERIXDB-3128?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17702045#comment-17702045
]
ASF subversion and git services commented on ASTERIXDB-3128:
------------------------------------------------------------
Commit 7ba271ac2d33704eaf8f5edc1587add0527dce37 in asterixdb's branch
refs/heads/master from Vijay Sarathy
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=7ba271ac2d ]
[ASTERIXDB-3128][COMP] Hashjoin hint with build generates warning
[ASTERIXDB-3126][COMP] CBO: hint productivity NPE if missing cardinality
estimate on collection
Change-Id: Ia26a912063aaf063a530acc7ff1a7a006f0ad0c9
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/17411
Tested-by: Jenkins <[email protected]>
Reviewed-by: Vijay Sarathy <[email protected]>
Reviewed-by: Ali Alsuliman <[email protected]>
Integration-Tests: Jenkins <[email protected]>
> 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)
