What? There's no Inverted Join in #Yugabyte​DB?
Of course not. That's not how SQL works.
If you want a Nested Loop to an Inverted Index, do like in PostgreSQL: declare a GIN index and let the DB choose the join method:
https://dev.to/yugabyte/inner-inverted-join-in-yugabytedb-postgresql-g22
Inner Inverted Join in YugabyteDB & PostgreSQL

In YugabyteDB, we have the same Join Methods as PostgreSQL, that are found in all SQL databases:...

DEV Community