It does have joins.
https://github.com/NLPchina/elasticsearch-sql/blob/5cd6ab639...
https://github.com/NLPchina/elasticsearch-sql/blob/5cd6ab639...
Edit: Actually the file you linked to was a test file. Hash join code is here [1], and it uses ES' scrolling feature to incrementally join, though it's not pipelined. Not sure scrolling is entirely appropriate for this; it will potentially hold an unpredictable amount of memory on the server end.
[1] https://github.com/NLPchina/elasticsearch-sql/blob/5cd6ab639...