[
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 <[email protected]>
Tested-by: Jenkins <[email protected]>
Reviewed-by: Dmitry Lychagin <[email protected]>
Reviewed-by: Ali Alsuliman <[email protected]>
> 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)
