Hi,
Newbies questions !
If I have a collection of movie info (title, rating, cast, full text of
Is there some way in ES to do something analogous to a join ? or do I need
Obviously I don't want to store the full script in an index every time a
Thanks
--elasticsearch+unsubscribe@googlegroups.com .https://groups.google.com/groups/opt_out .
Anyone help me on this ?
On Wednesday, August 21, 2013 11:29:03 AM UTC+7, Justin MacCarthy wrote:
Hi,
Newbies questions !
If I have a collection of movie info (title, rating, cast, full text of
Is there some way in ES to do something analogous to a join ? or do I need
Obviously I don't want to store the full script in an index every time a
Thanks
--elasticsearch+unsubscribe@googlegroups.com .https://groups.google.com/groups/opt_out .
spinscale
August 22, 2013, 9:56am
3
Hey,
you might want to check the terms lookup mechanism mentioned here:
Power insights and outcomes with the Elasticsearch Platform and AI. See into your data and find answers that matter with enterprise solutions designed to help you build, observe, and protect. Try Elasticsearch free today.
You could also use parent/child functionality to model this, this really
Power insights and outcomes with the Elasticsearch Platform and AI. See into your data and find answers that matter with enterprise solutions designed to help you build, observe, and protect. Try Elasticsearch free today.
Power insights and outcomes with the Elasticsearch Platform and AI. See into your data and find answers that matter with enterprise solutions designed to help you build, observe, and protect. Try Elasticsearch free today.
both solutions are worth trying out in your case, I guess.
--Alex
On Thu, Aug 22, 2013 at 5:03 AM, Justin MacCarthy <justin.maccarthy@gmail.com > wrote:
Anyone help me on this ?
On Wednesday, August 21, 2013 11:29:03 AM UTC+7, Justin MacCarthy wrote:
Hi,
Newbies questions !
If I have a collection of movie info (title, rating, cast, full text of
Is there some way in ES to do something analogous to a join ? or do I
Obviously I don't want to store the full script in an index every time a
Thanks
--elasticsearch+unsubscribe@googlegroups.com .https://groups.google.com/groups/opt_out .
--elasticsearch+unsubscribe@googlegroups.com .https://groups.google.com/groups/opt_out .
mattweber
August 22, 2013, 12:04pm
4
FYI, my terms lookup by query pull request might interest you.
elastic:master ← mattweber:terms_lookup_by_query
opened 05:20PM - 01 Jul 13 UTC
This PR adds support for generating a terms filter based on the field values
of … documents matching a specified lookup query/filter. The value of the
configurable "path" field is collected from the field data cache for each
document matching the lookup query/filter and is then used to filter the main
query. This is can also be called a join filter.
This PR abstracts the TermsLookup functionality in order to support multiple
lookup methods. The existing functionality is moved into FieldTermsLookup and
the new query based lookup is in QueryTermsLookup. All existing caching
functionality works with the new query based lookup for increased performance.
During testing of I found that one of the performance bottlenecks was
generating the Lucene TermsFilter on large sets of terms (probably since
it sorts the terms). I have created a FieldDataTermsFilter that uses the
field data cache to lookup value of the field being filtered and compare it to
the set of gathered terms. This significantly increased performance at the
cost of higher memory usage. Currently a TermsFilter is used when the number
of filtering terms is less than 1024 and the FieldDataTermsFilter is used
for everything else. This should eventually be configurable or we need to
perform some test to find the optimal value.
Examples:
Replicate a has_child query by joining on the child's "pid" field to the
parent's "id" field for each child that has the tag "something".
```
curl -XPOST 'http://localhost:9200/parentIndex/_search' -d '{
"query": {
"constant_score": {
"filter": {
"terms": {
"id": {
"index": "childIndex",
"type": "childType",
"path": "pid",
"query": {
"term": {
"tag": "something"
}
}
}
}
}
}
}
}'
```
Lookup companies that offer products or services mentioning elasticsearch.
Notice that products and services are kept in their own indices.
```
curl -XPOST 'http://localhost:9200/companies/_search' -d '{
"query": {
"constant_score": {
"filter": {
"terms": {
"company_id": {
"indices": ["products", "services"],
"path": "company_id",
"filter": {
"term": {
"description": "elasticsearch"
}
}
}
}
}
}
}
}'
```
Thanks,
On Thursday, August 22, 2013, Alexander Reelsen wrote:
Hey,
you might want to check the terms lookup mechanism mentioned here:Elasticsearch Platform — Find real-time answers at scale | Elastic
You could also use parent/child functionality to model this, this reallyElasticsearch Platform — Find real-time answers at scale | Elastic Elasticsearch Platform — Find real-time answers at scale | Elastic
both solutions are worth trying out in your case, I guess.
--Alex
On Thu, Aug 22, 2013 at 5:03 AM, Justin MacCarthy <justin.maccarthy@gmail.com <javascript:_e({}, 'cvml',
Anyone help me on this ?
On Wednesday, August 21, 2013 11:29:03 AM UTC+7, Justin MacCarthy wrote:
Hi,
Newbies questions !
If I have a collection of movie info (title, rating, cast, full text of
Is there some way in ES to do something analogous to a join ? or do I
Obviously I don't want to store the full script in an index every time a
Thanks
--elasticsearch+unsubscribe@googlegroups.com <javascript:_e({},https://groups.google.com/groups/opt_out .
--elasticsearch+unsubscribe@googlegroups.com <javascript:_e({},https://groups.google.com/groups/opt_out .
--
--elasticsearch+unsubscribe@googlegroups.com .https://groups.google.com/groups/opt_out .