# \[ANNOUNCE\] es-sql 1.0.1 Query Elasticsearch using SQL

**URL:** <https://discuss.elastic.co/t/announce-es-sql-1-0-1-query-elasticsearch-using-sql/43015>\
**Category:** Elastic Community and Ecosystem\
**Created:** [February 29, 2016, 4:12pm UTC](https://discuss.elastic.co/t/announce-es-sql-1-0-1-query-elasticsearch-using-sql/43015 "2016-02-29T16:12:25Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![taowen](https://avatars.discourse-cdn.com/v4/letter/t/6f9a4e/32.png) [@taowen](https://discuss.elastic.co/u/taowen)\
**Post date:** [February 29, 2016, 4:12pm UTC](https://discuss.elastic.co/t/announce-es-sql-1-0-1-query-elasticsearch-using-sql/43015/1 "2016-02-29T16:12:25Z")

</div>

> **[taowen/es-monitor](https://github.com/taowen/es-monitor)**
>
> es-monitor - query metric from elasticsearch using sql

We love SQL and want to leverage the full power of elasticsearch. Using syntax like

```auto
$ cat << EOF | ./es_query.py http://127.0.0.1:9200
    WITH SELECT MAX(market_cap) AS max_all_times FROM symbol AS all_symbols;
    WITH SELECT MAX(market_cap) AS max_at_2000 FROM all_symbols 
        WHERE ipo_year=2000 AS year_2000
EOF

```

You can create drill-down aggregation without create deeply nested json

It is written in Python, it can be:

1. a python library to query elasticsearch
2. a console command
3. a http server providing SQL api

If you like Java, there is also a Java version coming.

---

<div class="post-metadata">

**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:** [February 29, 2016, 9:41pm UTC](https://discuss.elastic.co/t/announce-es-sql-1-0-1-query-elasticsearch-using-sql/43015/2 "2016-02-29T21:41:20Z")

</div>

We also welcome announcements like these in this category - [https://discuss.elastic.co/c/annoucements/community-ecosystem](https://discuss.elastic.co/c/annoucements/community-ecosystem)

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 1:44pm UTC](https://discuss.elastic.co/t/announce-es-sql-1-0-1-query-elasticsearch-using-sql/43015/3 "2017-07-06T13:44:33Z")

</div>