Broadcast Join Syntax

[laura.luckert]

Hi all,
what is the syntax for broadcast joins in ONE DATA sql processors?

[pedro.jaime-gonzalez]

Hi, you mean something like this:

SELECT /*+ BROADCAST(s) */ f.* FROM firstInputTable f...

with the s in the hint being the secondInputTable

[maximilian.schriml]

See also here for the syntax of other join hints:

https://spark.apache.org/docs/latest/sql-ref-syntax-qry-select-hints.html#join-hints