[
https://issues.apache.org/jira/browse/ASTERIXDB-3090?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17641022#comment-17641022
]
ASF subversion and git services commented on ASTERIXDB-3090:
------------------------------------------------------------
Commit 691e93bf945d97c58038fd087d3bd2c215b97461 in asterixdb's branch
refs/heads/master from Vijay Sarathy
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=691e93bf94 ]
[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]>
> 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
>
> - 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)
