# SQL "join" in Elasticsearch? Yes you can **URL:** https://discuss.elastic.co/t/sql-join-in-elasticsearch-yes-you-can/38632 **Category:** Elasticsearch **Created:** [January 7, 2016, 2:49pm UTC](https://discuss.elastic.co/t/sql-join-in-elasticsearch-yes-you-can/38632 "2016-01-07T14:49:44Z") **Posts on this page:** 4 **Page:** 1
### Author: ![rtkmhart](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rtkmhart/32/7025_2.png) [@rtkmhart](https://discuss.elastic.co/u/rtkmhart) #### Post date: [January 7, 2016, 2:49pm UTC](https://discuss.elastic.co/t/sql-join-in-elasticsearch-yes-you-can/38632/1 "2016-01-07T14:49:44Z")
My colleagues put this tool together as part of a hackathon, and after cleaning it up our company has graciously allowed us to make it open source. Announcing "PostgreSQL foreign data wrapper for Elasticsearch" available at [https://github.com/rtkwlf/esfdw](https://github.com/rtkwlf/esfdw). It's still in an early stage but it does work. Contributions are more than welcome. What does it do? You can write SQL queries against PostgreSQL which will use Elasticsearch as the backend. I won't copy the whole README here, but a few use cases: - Writing SQL JOIN queries against Elasticsearch documents and letting the PostgreSQL engine do the heavy lifting - Running window functions on data stored in Elasticsearch - Applying PostgreSQL aggregations that do not currently have a native Elasticsearch equivalent Github: [https://github.com/rtkwlf/esfdw](https://github.com/rtkwlf/esfdw) Pypi: [https://pypi.python.org/pypi/esfdw](https://pypi.python.org/pypi/esfdw) cheers mike ---
### Author: ![Ivan](https://avatars.discourse-cdn.com/v4/letter/i/df788c/32.png) [@Ivan](https://discuss.elastic.co/u/Ivan) #### Post date: [January 7, 2016, 6:59pm UTC](https://discuss.elastic.co/t/sql-join-in-elasticsearch-yes-you-can/38632/2 "2016-01-07T18:59:16Z")
"rtkwlf/esfdw" Never seen such a cryptic username/reponame combo! 🙂 ---
### Author: ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm) #### Post date: [January 7, 2016, 8:26pm UTC](https://discuss.elastic.co/t/sql-join-in-elasticsearch-yes-you-can/38632/3 "2016-01-07T20:26:36Z")
Thanks for sharing this! Feel free to also post future releases in [https://discuss.elastic.co/c/annoucements/community-plugins](https://discuss.elastic.co/c/annoucements/community-plugins) ---
### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system) #### Post date: [July 5, 2017, 11:26pm UTC](https://discuss.elastic.co/t/sql-join-in-elasticsearch-yes-you-can/38632/4 "2017-07-05T23:26:17Z")