You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "Wail Y. Alkowaileet (Jira)" <ji...@apache.org> on 2023/02/13 23:48:00 UTC
[jira] [Created] (ASTERIXDB-3113) Allow the use hash-join with redundant variables
Wail Y. Alkowaileet created ASTERIXDB-3113:
----------------------------------------------
Summary: Allow the use hash-join with redundant variables
Key: ASTERIXDB-3113
URL: https://issues.apache.org/jira/browse/ASTERIXDB-3113
Project: Apache AsterixDB
Issue Type: Bug
Components: COMP - Compiler
Reporter: Wail Y. Alkowaileet
Assignee: Wail Y. Alkowaileet
The following join currently uses broadcast join instead of hash-joinÂ
{code:java}
SELECT COUNT(*)
FROM Orders o, LineItem l
WHERE o.o_orderkey = l.l_orderkey
AND o.o_orderkey = l.l_suppkey{code}
As a result of having one attribute on one side and two attributes on the other side. The broadcast join would be much slower in most cases. Hence, this should be rectified.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)