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/05/05 15:08:00 UTC

[jira] [Updated] (ASTERIXDB-3113) Allow the use hash-join with redundant variables

     [ https://issues.apache.org/jira/browse/ASTERIXDB-3113?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Wail Y. Alkowaileet updated ASTERIXDB-3113:
-------------------------------------------
    Labels: triaged  (was: )

> 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
>            Priority: Major
>              Labels: triaged
>
> 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)