class cast error on multi query

[marcopyre]

Hi, i'm new on opendistro and i got an issue on a request who should be valid, i tested this one on sqlite and it was working but it's showing me this error on opendistro:

there is my request:

my data look like this:

i'm running on opendistro 1.13.2

[dai-chen]

Hi @marcopyre , thanks for reporting the issue! JOIN between is not supported yet. Will try to add this in future.