[
https://issues.apache.org/jira/browse/ASTERIXDB-3090?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17681868#comment-17681868
]
ASF subversion and git services commented on ASTERIXDB-3090:
------------------------------------------------------------
Commit 37dd73a63b54b849c9bfe8c7f8fb3fa070433e5b in asterixdb's branch
refs/heads/master from Vijay Sarathy
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=37dd73a63b ]
[ASTERIXDB-3090][COMP] Enhance syntax and semantics of hash/broadcast join hints
- user model changes: yes
- storage format changes: no
- interface changes: no
Details:
This patch is to allow users to specify the build/probe side
of a hash join and the broadcast side of a broadcast hash join.
- Enhance the hash join hint "hashjoin" to specify the dataset
with which to build/probe the hash table in the hash join.
Example:
A.field1 /*+ hashjoin build(B) */ = B.field2
A.field1 /*+ hashjoin probe(B) */ = B.field2
- Enhance the broadcast join hint "hash-bcast" to specify
the dataset to broadcast.
Example:
A.field1 /*+ hash-bcast(B) */ = B.field2
Change-Id: I67f3ea5bbd9dd4f5f4b836e765f42ccc1d7b53cc
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/17280
Reviewed-by: Vijay Sarathy <[email protected]>
Reviewed-by: Ali Alsuliman <[email protected]>
Integration-Tests: Jenkins <[email protected]>
Tested-by: Jenkins <[email protected]>
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/17339
Reviewed-by: Michael Blow <[email protected]>
Tested-by: Michael Blow <[email protected]>
> Enhance syntax and semantics of hash/broadcast join hints
> ---------------------------------------------------------
>
> Key: ASTERIXDB-3090
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3090
> Project: Apache AsterixDB
> Issue Type: Improvement
> Components: COMP - Compiler
> Reporter: Vijay Sarathy
> Assignee: Vijay Sarathy
> Priority: Major
> Fix For: 0.9.8
>
>
> - Enhance the hash join hint "hashjoin" to specify the dataset
> with which to build/probe the hash table in the hash join.
> Example:
> A.field1 /*+ hashjoin build(B) */ = B.field2
> A.field1 /*+ hashjoin probe(B) */ = B.field2
> - Enhance the broadcast join hint "hash-bcast" to specify
> the dataset to broadcast.
> Example:
> A.field1 /*+ hash-bcast(B) */ = B.field2
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
