[
https://issues.apache.org/jira/browse/ASTERIXDB-3363?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ian Maxon updated ASTERIXDB-3363:
---------------------------------
Labels: triaged (was: )
> 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)
