Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
The Broadcast hint (/+ bcast /) is using the order of the datasets in WHERE clause for a join to choose the broadcasting dataset. This is not consistent with other types of joins such as Hybrid Hash Join and Indexed Nested Loop Join. It can also cause confusion for both user and AsterixDB if the query has more than one condition in the WHERE clause for a join, and order of datasets in these conditions are consistent.