Queries regarding sql-jdbc

Hi,

I am starting to use the opendistro-sql-jdbc support. Need few clarifications on the same.

  1. Are joins on indices similar to sql possible with this library. I have tried few join queries, it works for few queries but i didnt find it working for aggregate functions like count, max, min etc. It gives the below error

Error:
{
“error”: {
“reason”: “There was internal problem at backend”,
“details”: “When using multiple indices, the mappings must be identical.”,
“type”: “VerificationException”
},
“status”: 503
}

  1. I have seen that the join query returns max of 200 results only. How do I get all the results?

Please help me with the same. Thanks in advance.