JOIN two RT indexes within a query

General Discussions - English
1

Is there a way to use JOIN in a query with two indexes? Like this MySQL query:

SELECT rt2.*
FROM rt2
JOIN rt1 ON rt1.field1 = rt2.field2
WHERE MATCH('@rt1.field3 SOMETEXT')

The problem is that I have to store almost all data from index rt1 in other indexes. I want to have something like JOIN on RT indexes to avoid such data duplication.

2

You can not use join. You could create distributed index with all your indexes however you can not reference or filter our by result set from another indexes.

3

Thank you for the reply.

4

@glukkkk It’s now possible in the dev version - Manticore Search Manual , will be released soon (in alpha/beta stage though).

Query examples: https://github.com/manticoresoftware/manticoresearch/blob/aaad011946f5dfea05d21aa89acfcd77a2159896/test/test_278/test.xml#L169-L185

Some nuances: INNER/LEFT JOIN · Issue #1673 · manticoresoftware/manticoresearch · GitHub

5

Thanks! We’ll definitely test it.