tree 48379e357bd46b619d4fddc5fb39ae45b2633e5a
parent 44e655bfcb5378e416c3135d10a3ff4740121ab5
author Vijay Sarathy <vijay.sarathy@couchbase.com> 1668983507 -0800
committer Vijay Sarathy <vijay.sarathy@couchbase.com> 1669769689 +0000

[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 <vijay.sarathy@couchbase.com>
Reviewed-by: Ali Alsuliman <ali.al.solaiman@gmail.com>
Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>
Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>