[jira] [Commented] (ASTERIXDB-3004) Join query is too slow

["ASF subversion and git services (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/ASTERIXDB-3004?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17476441#comment-17476441 ] 

ASF subversion and git services commented on ASTERIXDB-3004:
------------------------------------------------------------

Commit 64786ba65f6b1b950534a46736c2b2eb3b6605e8 in asterixdb's branch refs/heads/master from Dmitry Lychagin
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=64786ba ]

[ASTERIXDB-3004][RT] Improve hash join performance

- user model changes: no
- storage format changes: no
- interface changes: no

Details:
- Improve hash join performance when joined values are NULL/MISSING
- Add SqlppHashJoinRQJTest to test different hash join scenarios

Change-Id: I8f0afb05908e8281f2865775e074d459964fe989
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/14784
Integration-Tests: Jenkins <je...@fulliautomatix.ics.uci.edu>
Tested-by: Jenkins <je...@fulliautomatix.ics.uci.edu>
Reviewed-by: Dmitry Lychagin <dm...@couchbase.com>
Reviewed-by: Ali Alsuliman <al...@gmail.com>


> Join query is too slow
> ----------------------
>
>                 Key: ASTERIXDB-3004
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-3004
>             Project: Apache AsterixDB
>          Issue Type: Bug
>          Components: RT - Runtime
>    Affects Versions: 0.9.7
>            Reporter: Dmitry Lychagin
>            Assignee: Dmitry Lychagin
>            Priority: Major
>             Fix For: 0.9.7
>
>
> The following query takes too long if values on both sides are MISSING
> {noformat}
> select count (*) from R, S where R.u256 = S.u256 {noformat}
>  



--
This message was sent by Atlassian Jira
(v8.20.1#820001)