Elasticsearch cross index Join plugin

Yes there is but its a different thing. This will do Joins across Indexes, that plugin will just give you a SQL syntax but will do only some form of joins - not in the range of millions.

Is there a plugin to let me use SQL to query Elasticsearch?