[ignite-3] branch main updated: IGNITE-16168 Bugyard feedback #36: Add info to docs on JOIN support (#786)

[ns...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

nsafonov pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/ignite-3.git


The following commit(s) were added to refs/heads/main by this push:
     new a9e94e1d2 IGNITE-16168 Bugyard feedback #36: Add info to docs on JOIN support (#786)
a9e94e1d2 is described below

commit a9e94e1d2d51a521a2d896dfe7292ed1d36b952f
Author: Nikita Safonov <73...@users.noreply.github.com>
AuthorDate: Tue Apr 19 12:37:31 2022 +0300

    IGNITE-16168 Bugyard feedback #36: Add info to docs on JOIN support (#786)
---
 docs/_docs/sql-reference/dml.adoc | 6 ++++++
 1 file changed, 6 insertions(+)

diff --git a/docs/_docs/sql-reference/dml.adoc b/docs/_docs/sql-reference/dml.adoc
index c215443a4..c10d0db74 100644
--- a/docs/_docs/sql-reference/dml.adoc
+++ b/docs/_docs/sql-reference/dml.adoc
@@ -32,6 +32,12 @@ FROM tableExpression
 [ HAVING booleanExpression ]
 ----
 
+=== JOINs
+
+Ignite supports colocated and non-colocated distributed SQL joins. Furthermore, if the data resides in different tables (caches), Ignite allows for cross-table joins as well.
+Joins between partitioned and replicated data sets always work without any limitations.
+However, if you join partitioned data sets, then you have to make sure that the keys you are joining on are either colocated or make sure you switched on the non-colocated joins parameter for a query.
+
 == INSERT
 
 Inserts data into a table.