News for hackers. Stuff that matters.
Re:Time series database Graphite seems to be falling into di... by meowface on Monday November 09, 2015 @02:12AM (#10531738)
I'm not sure I'd consider that a DSL. It's unwieldy to write a full JSON object for every one-off query I want to do.

Using one of their examples, this:

    {
      "query": {
        "filtered": {
          "query": {
            "bool": {
              "must": [{"match": {"title": "python"}}],
              "must_not": [{"match": {"description": "beta"}}]
            }
          },
          "filter": {"term": {"category": "search"}}
        }
      },
      "aggs" : {
        "per_tag": {
          "terms": {"field": "tags"},
          "aggs": {
            "max_lines": {"max": {"field": "lines"}}
          }
        }
      }
    }
would be the following Splunk query:

    title=python description!=beta | stats max(lines) by tags
It would be nice if there was some kind of query compiler that could generate ES JSON from an expressive query language.
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.