Storing queries in ElasticSearch and use it like a view

[obfischer]

It is easy to query ElasticSearch but exchanging with others is not as easy as I would like to have it.

I would like to have the possibillity to save queries to ElasticSearch in a way similar to the percolator API:

url -XPUT localhost:9200/_query/myqueryname -d '{
    "query" : {
        "term" : {
            "field1" : "value1"
        }
    }
}'

Later I would like to execute the query via

curl -X GET localhost:9200/_query/myqueryname

I think such a functionality is not available in ElasticSearch at the moment. Or?

[MaineC]

Hi Oliver,

What you describe sounds pretty similar to a plugin I'm currently working on: My goal goes a bit further in that I would like to be able to store a query template that at query time can then be filled with actual parameters. For a first stab at this functionality see here: https://github.com/MaineC/elasticsearch-query-templates

Storing and later loading such templates is what I am looking into right now.

Isabel

[uboness]

+1 on Isabel's comment... Plus we currently support attaching filters to aliases... These are not queries (so no scoring) but they can serve as a filtered views into your data

http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/indices-aliases.html#filtered

On Wed, Jan 15, 2014 at 9:29 AM, Isabel Drost-Fromm
notifications@github.com wrote:

Hi Oliver,
What you describe sounds pretty similar to a plugin I'm currently working on: My goal goes a bit further in that I would like to be able to store a query template that at query time can then be filled with actual parameters. For a first stab at this functionality see here: https://github.com/MaineC/elasticsearch-query-templates
Storing and later loading such templates is what I am looking into right now.

Isabel

Reply to this email directly or view it on GitHub:
#4741 (comment)

[javanna]

Hi @obfischer , did you have a look at the search template feature that got released with 1.1? That should be what you were looking for, have a look at #5637 as well for further improvements on it.

Closing this issue for now, feel free to reopen though if you think search templates don't address it.

[obfischer]

Hi @javanna, yes this is what I suggested. Great to see this available.