[
https://issues.apache.org/jira/browse/ASTERIXDB-3363?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17845403#comment-17845403
]
ASF subversion and git services commented on ASTERIXDB-3363:
------------------------------------------------------------
Commit 308c61dff433d28f775eb2791b14b652718f3fa8 in asterixdb's branch
refs/heads/master from Vijay Sarathy
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=308c61dff4 ]
[ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are
multiple join predicates.
Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196
Integration-Tests: Jenkins <[email protected]>
Tested-by: Jenkins <[email protected]>
Reviewed-by: <[email protected]>
Reviewed-by: Vijay Sarathy <[email protected]>
> CBO not choosing indexnl join when there are multiple join predicates
> ---------------------------------------------------------------------
>
> Key: ASTERIXDB-3363
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3363
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: COMP - Compiler
> Reporter: Vijay Sarathy
> Assignee: Vijay Sarathy
> Priority: Major
> Labels: triaged
>
> CBO does not pick an indexnl join when there is more than one join predicate.
> The following query results in a hash join plan even though there is a valid
> indexnl hint on one of the predicates.
> select * from R join S on tobigint(R.u64) = S.u64 and tobigint(R.u256) /*+
> indexnl(S_u256_idx) */ = S.u256 where R.rand < 10;
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
