Re: Group by field and then sum the groups

[Cameron Barker]

This worked perfectly!  Thank you for your help.

On Wednesday, August 6, 2014 3:49:57 AM UTC-4, Tihomir Lichev wrote:

 Thanks! You're absolutely right. Copy/paste error :)

 {
  aggs: {
user_likes: {
  terms: {
field: user_id
  }, 
  aggs: {
likes_sum: {
  sum: {
field: likes
  }
}
  }
}
  }
 }

 06 август 2014, сряда, 10:06:38 UTC+3, Jun Ohtani написа:

 Hi,

 I think second aggs use sum instead of terms, in likes_sum.


 2014-08-06 14:32 GMT+09:00 Tihomir Lichev sho...@gmail.com:

 You can use aggregations:
 {
  aggs: {
user_likes: {
  terms: {
field: user_id
  }, 
  aggs: {
likes_sum: {
  terms: {
field: likes
  }
}
  }
}
  }
 }


 05 август 2014, вторник, 23:11:59 UTC+3, Cameron Barker написа:

 Hi all,

 I have an elastic database of posts, each post has a *user_id* and has 
 *likes* field.  My goal is to output for a query how many likes in 
 total each user has.

 I wondered if any one had any advice/direction I could take to achieve 
 this?

 input:
 {user_id: 10, likes: 20}
 {user_id: 9, likes: 10}
 {user_id: 10, likes: 25}
 {user_id: 9, likes: 15}

 output:
 User: 10 likes: 45
 User: 9 likes: 25

  -- 
 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 elasticsearc...@googlegroups.com.
 To view this discussion on the web visit 
 https://groups.google.com/d/msgid/elasticsearch/7bec5f9a-16cf-4723-87a6-7e95de45d0ea%40googlegroups.com
  
 https://groups.google.com/d/msgid/elasticsearch/7bec5f9a-16cf-4723-87a6-7e95de45d0ea%40googlegroups.com?utm_medium=emailutm_source=footer
 .

 For more options, visit https://groups.google.com/d/optout.




 -- 
 ---
 Jun Ohtani
 blog : http://blog.johtani.info
  


-- 
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+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/elasticsearch/fb530eeb-0a9f-4460-905a-92f0d74fa5ff%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Group by field and then sum the groups

[Cameron Barker]

Hi all,

I have an elastic database of posts, each post has a *user_id* and has 
*likes* field.  My goal is to output for a query how many likes in total 
each user has.

I wondered if any one had any advice/direction I could take to achieve this?

input:
{user_id: 10, likes: 20}
{user_id: 9, likes: 10}
{user_id: 10, likes: 25}
{user_id: 9, likes: 15}

output:
User: 10 likes: 45
User: 9 likes: 25

-- 
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+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/elasticsearch/d016c5d0-ad03-488e-9c7b-73cf85999e10%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Unique data by referencing 2 fields

[Cameron Barker]

Hi all,

Would it be possible to get unique items from an elastic search database 
that reference 2 fields for uniqueness, all while using only elastic search 
or a plug in?

*I.E.*
*Initial Data:*
{
 provider: tumblr
 text: I need to get this.
}
{
 provider: twitter
 text: I need to get this.
}
{
 provider: tumblr
 text: I need to get this.
}

*Return:*
{
 provider: twitter
 text: I need to get this.
}
{
 provider: tumblr
 text: I need to get this.
}

-- 
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+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/elasticsearch/e67f33df-643e-4840-a056-271b5db217ee%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.