How Using Analytics Indexes in JOIN

Analytics
, ,
3

Thank You It is real working.

But due to the use of the index, there was a problem with other queries.
“code”: 25000,
“msg”: “Internal error”,

In the query which do not use field from the index.
For example:

SELECT VALUE OBJECT_CONCAT(col_doc.data.en, IFMISSING(col_doc.data.`ru`, {}), {'doc_id': col_doc.id, 'ctime': META(col_doc).cas}, {})
  FROM `deploy_dev`.`game`.`data` col_doc
  WHERE (col_doc.data.en.provider.id IN []
      AND ARRAY_LENGTH(ARRAY_INTERSECT(ARRAY_STAR(col_doc.data.en.categories).alias, [
      "slots"
    ]))>0
      AND TRUE IN [ARRAY_LENGTH(col_doc.data.en.allowed_countries) = 0, "DE"  IN col_doc.data.en.allowed_countries]
      AND TRUE IN [ARRAY_LENGTH(col_doc.data.en.restricted_countries) = 0,  "DE"  NOT IN col_doc.data.en.restricted_countries]
      AND col_doc.data.en.codes.desktop!="")

Result is “code”: 25000, “msg”: “Internal error”,

If I remove index, query is working
If I remove condition “DE” IN col_doc.data.en.allowed_countries , query is working

Please advidvice me