[teiid-issues] [JBoss JIRA] (TEIID-2539) Add "allow-join" metadata based join processing on Foreign keys

Add "allow-join" metadata based join processing on Foreign keys --------------------------------------------------------------- Key: TEIID-2539 URL: https://issues.jboss.org/browse/TEIID-2539 Project: Teiid Issue Type: Enhancement Components: Query Engine Reporter: Ramesh Reddy Assignee: Steven Hawkins Fix For: 8.4.1, 8.5 MongoDB source generally does not support any joins between it collection of documents. However, one document can be embedded in other parent document, then those documents can be viewed as JOIN based documents. Teiid's MongoDB translator takes the above as an approach to define each collection as a table, and provides ways to embed related tables into parent document for supporting the JOIN in SQL. However, there may be situations, there is PK-FK relation between two tables, but they are not embeded, in those situations based on the capabilities of translator the query engine still pushes the join into translator for processing, but translator can not handle the join. In these situations, where the collections are not embedded the query engine need to behave as if translator does not support JOIN. The proposal here is to add a extension metadata on FOREIGN KEY called "allow-joins=false", which query engine will consult along with the capabilities of the translator before it pushes the JOIN to the source translator. This would be useful in non-relational translators to selectively support JOINS where possible.