We love SQL and want to leverage the full power of elasticsearch. Using syntax like
$ 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:
- a python library to query elasticsearch
- a console command
- a http server providing SQL api
If you like Java, there is also a Java version coming.