Output query results to document and index immediately


(Joanna Kochaniak) #1

Does ES provide the ability to write the results (ids) of a query directly
to a new document and index it, instead of passing them back to the client?
Or is there a plugin that provides this functionality? We are running
queries that randomize documents and we'd like to be able to rerun the same
query several times. Writing the ids to a document allows us to use the terms
lookuphttp://www.elasticsearch.org/guide/en/elasticsearch/reference/current/query-dsl-terms-filter.html#_terms_lookup_mechanism query
to quickly recreate the same randomization, without needing to pass the ids
back and forth. However, for the initial query we still have to pull back
all the ids, create a document, then pass that document back to ES. Because
retrieving the ids takes so long, we'd like to skip that step.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/92c924e9-377d-4c9a-8f0a-cddb7eff9150%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


(Andrew Cholakian-2) #2

So far as I know, there is no equivalent to a SQL statement that performs
an INSERT based on a SELECT


Andrew Cholakian
Developer, Found Hosted Elasticsearch
www.found.no, @foundsays

On Thursday, December 12, 2013 1:43:43 PM UTC-8, Joanna Kochaniak wrote:

Does ES provide the ability to write the results (ids) of a query directly
to a new document and index it, instead of passing them back to the client?
Or is there a plugin that provides this functionality? We are running
queries that randomize documents and we'd like to be able to rerun the same
query several times. Writing the ids to a document allows us to use the terms
lookuphttp://www.elasticsearch.org/guide/en/elasticsearch/reference/current/query-dsl-terms-filter.html#_terms_lookup_mechanism query
to quickly recreate the same randomization, without needing to pass the ids
back and forth. However, for the initial query we still have to pull back
all the ids, create a document, then pass that document back to ES. Because
retrieving the ids takes so long, we'd like to skip that step.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/5de31c26-cadb-4b5d-928d-f36f57c73806%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


(system) #3