Github user gatorsmile commented on the issue:
https://github.com/apache/spark/pull/16925
A late LGTM. : )
Normally, we do not encourage users to define hints inside a view. Users
can add a BROADCAST hint when they define a persistent view. That will be
stored in the catalog. The hint will take an effect, as long as this view is
not cached.
Users can also use a BROADCAST hint for the operators (e.g., INTERSECT)
that will be rewritten to a Join in optimizer.
```Scala
sql("CREATE VIEW v AS SELECT /*+ BROADCAST(u) */ key FROM u")
sql("SELECT /*+ BROADCAST(t) */ * FROM t INTERSECT SELECT * FROM v")
```
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
