How do a model this in elasticsearch

Elastic Stack Elasticsearch
#1

Hi,

Newbies questions !

If I have a collection of movie info (title, rating, cast, full text of
script ) and I have a collection of reviews , user A gave "Terminator 5
stars"

Is there some way in ES to do something analogous to a join ? or do I need
to de-normalize the data ?
What is the term for this in ES?

Obviously I don't want to store the full script in an index every time a
user reviews it, but I do want to find users the like topics such as
"Skynet"

Thanks
J

--
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.
For more options, visit https://groups.google.com/groups/opt_out.

#2

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
script ) and I have a collection of reviews , user A gave "Terminator 5
stars"

Is there some way in ES to do something analogous to a join ? or do I need
to de-normalize the data ?
What is the term for this in ES?

Obviously I don't want to store the full script in an index every time a
user reviews it, but I do want to find users the like topics such as
"Skynet"

Thanks
J

--
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.
For more options, visit https://groups.google.com/groups/opt_out.

#3

Hey,

you might want to check the terms lookup mechanism mentioned here:
http://www.elasticsearch.org/guide/reference/query-dsl/terms-filter/

You could also use parent/child functionality to model this, this really
depends on what kind of queries you plan to execute and how your model your
data in elasticsearch...
http://www.elasticsearch.org/guide/reference/query-dsl/has-parent-query/
http://www.elasticsearch.org/guide/reference/query-dsl/has-child-query/

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
script ) and I have a collection of reviews , user A gave "Terminator 5
stars"

Is there some way in ES to do something analogous to a join ? or do I
need to de-normalize the data ?
What is the term for this in ES?

Obviously I don't want to store the full script in an index every time a
user reviews it, but I do want to find users the like topics such as
"Skynet"

Thanks
J

--
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.
For more options, visit https://groups.google.com/groups/opt_out.

--
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.
For more options, visit https://groups.google.com/groups/opt_out.

#4

FYI, my terms lookup by query pull request might interest you.

Thanks,
Matt Weber

On Thursday, August 22, 2013, Alexander Reelsen wrote:

Hey,

you might want to check the terms lookup mechanism mentioned here:
http://www.elasticsearch.org/guide/reference/query-dsl/terms-filter/

You could also use parent/child functionality to model this, this really
depends on what kind of queries you plan to execute and how your model your
data in elasticsearch...
http://www.elasticsearch.org/guide/reference/query-dsl/has-parent-query/
http://www.elasticsearch.org/guide/reference/query-dsl/has-child-query/

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',
'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
script ) and I have a collection of reviews , user A gave "Terminator 5
stars"

Is there some way in ES to do something analogous to a join ? or do I
need to de-normalize the data ?
What is the term for this in ES?

Obviously I don't want to store the full script in an index every time a
user reviews it, but I do want to find users the like topics such as
"Skynet"

Thanks
J

--
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 <javascript:_e({},
'cvml', 'elasticsearch%2Bunsubscribe@googlegroups.com');>.
For more options, visit https://groups.google.com/groups/opt_out.

--
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 <javascript:_e({},
'cvml', 'elasticsearch%2Bunsubscribe@googlegroups.com');>.
For more options, visit https://groups.google.com/groups/opt_out.

--
Thanks,
Matt Weber

--
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.
For more options, visit https://groups.google.com/groups/opt_out.

#5