Re:Time series database Graphite seems to be falling into di...
by illumen on Monday November 09, 2015 @03:27AM
(#10531894)
The linked python dsl does pretty well. Not as nice as your reduced dsl but.
s = Search(using=client, index="my-index") \
.filter("term", category="search") \
.query("match", title="python") \
.query(~Q("match", description="beta"))
Re:Time series database Graphite seems to be falling into di...
by michaelcampbell on Monday November 09, 2015 @10:40AM
(#10533597)
https://github.com/NLPchina/elasticsearch-sql/
does exactly that with a reasonably good subset of SQL and ES query language mixed in.
It operates in 2 modes; in one it runs the query, in another it spits back out what the equivalent ES JSON query is. We use this as a quick prototyping tool and modify the ES query as needed, as most of us here still "think" in SQL for a lot of things.
Using one of their examples, this:
would be the following Splunk query: It would be nice if there was some kind of query compiler that could generate ES JSON from an expressive query language.