Hi, I'm new to Elasticsearch and struggling with the design.
I have 2 indices. One is 'comment' index which contains comments users wrote, the other is 'ex_comment' which also contains comments but crawling data.
What I want to make is this.
Like 'Facebook like', I want to show how many users like of each comment.
Since the user should know if the user hit like on each comment or not,
Just adding 'counter' field is not enough, and I thought there should be the mapping tables as below.
(fields - both are same)
"comment_id" // id from parent index
"user_id" // user who hits like on the comment
These two indices will be childs of each parent indices.
I've heard that Elasticsearch can't have multiple parents. So I thought I need 2 indices respectively.
And I'll be using 'has-child' query if I decide to use this design.
I'm not sure if this would be the best design for managing 'likes'. I'm also worried about the performance since 'hit like' will be frequently executed.