I am starting to use the opendistro-sql-jdbc support. Need few clarifications on the same.
- 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
“reason”: “There was internal problem at backend”,
“details”: “When using multiple indices, the mappings must be identical.”,
- 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.