You are viewing a plain text version of this content. The canonical link for it is here.

Posted to notifications@asterixdb.apache.org by "Ian Maxon (Jira)" <ji...@apache.org> on 2022/12/02 18:06:00 UTC

[jira] [Updated] (ASTERIXDB-3090) Enhance syntax and semantics of hash/broadcast join hints

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

Ian Maxon updated ASTERIXDB-3090:
---------------------------------
    Fix Version/s: 0.9.8

> 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)