Skip to content

Instantly share code, notes, and snippets.

@robertogyn19

robertogyn19/gist:7cb165c12f9dbe21bb1a

Last active August 29, 2015 14:04
Show Gist options
  • Save robertogyn19/7cb165c12f9dbe21bb1a to your computer and use it in GitHub Desktop.
Save robertogyn19/7cb165c12f9dbe21bb1a to your computer and use it in GitHub Desktop.
Download ZIP
ElasticSearch date_histogram per user
Raw
gistfile1.js
// ElasticSearch query
{
"aggs": {
"range": {
"date_histogram": {
"field": "sms.sndDate",
"interval": "1h",
"format": "dd/MM HH:mm"
},
"aggs": {
"terms_agg": {
"terms": {
"field": "name"
}
}
}
}
},
"size": 0
}
// ElasticSearch response
{
"took":35,
"timed_out":false,
"_shards":{
"total":5,
"successful":5,
"failed":0
},
"hits":{
"total":999999,
"max_score":0.0,
"hits":[
]
},
"aggregations":{
"range":{
"buckets":[
{
"key_as_string":"01/04 00:00",
"key":1396310400000,
"doc_count":43199,
"terms_agg":{
"buckets":[
{
"key":"name_4",
"doc_count":8678
},
{
"key":"name_0",
"doc_count":8664
},
{
"key":"name_1",
"doc_count":8641
},
{
"key":"name_2",
"doc_count":8629
},
{
"key":"name_3",
"doc_count":8587
}
]
}
},
{
"key_as_string":"01/04 01:00",
"key":1396314000000,
"doc_count":43508,
"terms_agg":{
"buckets":[
{
"key":"name_2",
"doc_count":8839
},
{
"key":"name_3",
"doc_count":8736
},
{
"key":"name_1",
"doc_count":8730
},
{
"key":"name_4",
"doc_count":8628
},
{
"key":"name_0",
"doc_count":8575
}
]
}
},
{
"key_as_string":"01/04 02:00",
"key":1396317600000,
"doc_count":43023,
"terms_agg":{
"buckets":[
{
"key":"name_0",
"doc_count":8673
},
{
"key":"name_2",
"doc_count":8658
},
{
"key":"name_4",
"doc_count":8601
},
{
"key":"name_1",
"doc_count":8593
},
{
"key":"name_3",
"doc_count":8498
}
]
}
},
{
"key_as_string":"01/04 03:00",
"key":1396321200000,
"doc_count":43437,
"terms_agg":{
"buckets":[
{
"key":"name_0",
"doc_count":8820
},
{
"key":"name_3",
"doc_count":8703
},
{
"key":"name_1",
"doc_count":8695
},
{
"key":"name_2",
"doc_count":8662
},
{
"key":"name_4",
"doc_count":8557
}
]
}
},
{
"key_as_string":"01/04 04:00",
"key":1396324800000,
"doc_count":43308,
"terms_agg":{
"buckets":[
{
"key":"name_3",
"doc_count":8783
},
{
"key":"name_1",
"doc_count":8684
},
{
"key":"name_2",
"doc_count":8628
},
{
"key":"name_4",
"doc_count":8613
},
{
"key":"name_0",
"doc_count":8600
}
]
}
},
{
"key_as_string":"01/04 05:00",
"key":1396328400000,
"doc_count":43888,
"terms_agg":{
"buckets":[
{
"key":"name_1",
"doc_count":8946
},
{
"key":"name_4",
"doc_count":8814
},
{
"key":"name_0",
"doc_count":8771
},
{
"key":"name_2",
"doc_count":8697
},
{
"key":"name_3",
"doc_count":8660
}
]
}
},
{
"key_as_string":"01/04 06:00",
"key":1396332000000,
"doc_count":43121,
"terms_agg":{
"buckets":[
{
"key":"name_1",
"doc_count":8789
},
{
"key":"name_2",
"doc_count":8637
},
{
"key":"name_3",
"doc_count":8626
},
{
"key":"name_0",
"doc_count":8567
},
{
"key":"name_4",
"doc_count":8502
}
]
}
},
{
"key_as_string":"01/04 07:00",
"key":1396335600000,
"doc_count":43848,
"terms_agg":{
"buckets":[
{
"key":"name_0",
"doc_count":8852
},
{
"key":"name_4",
"doc_count":8790
},
{
"key":"name_3",
"doc_count":8753
},
{
"key":"name_1",
"doc_count":8743
},
{
"key":"name_2",
"doc_count":8710
}
]
}
},
{
"key_as_string":"01/04 08:00",
"key":1396339200000,
"doc_count":43272,
"terms_agg":{
"buckets":[
{
"key":"name_4",
"doc_count":8695
},
{
"key":"name_2",
"doc_count":8687
},
{
"key":"name_1",
"doc_count":8680
},
{
"key":"name_3",
"doc_count":8629
},
{
"key":"name_0",
"doc_count":8581
}
]
}
},
{
"key_as_string":"01/04 09:00",
"key":1396342800000,
"doc_count":43692,
"terms_agg":{
"buckets":[
{
"key":"name_1",
"doc_count":8855
},
{
"key":"name_4",
"doc_count":8743
},
{
"key":"name_0",
"doc_count":8738
},
{
"key":"name_2",
"doc_count":8685
},
{
"key":"name_3",
"doc_count":8671
}
]
}
},
{
"key_as_string":"01/04 10:00",
"key":1396346400000,
"doc_count":43508,
"terms_agg":{
"buckets":[
{
"key":"name_0",
"doc_count":8817
},
{
"key":"name_2",
"doc_count":8783
},
{
"key":"name_4",
"doc_count":8662
},
{
"key":"name_3",
"doc_count":8651
},
{
"key":"name_1",
"doc_count":8595
}
]
}
},
{
"key_as_string":"01/04 11:00",
"key":1396350000000,
"doc_count":43403,
"terms_agg":{
"buckets":[
{
"key":"name_4",
"doc_count":8808
},
{
"key":"name_2",
"doc_count":8719
},
{
"key":"name_3",
"doc_count":8693
},
{
"key":"name_1",
"doc_count":8613
},
{
"key":"name_0",
"doc_count":8570
}
]
}
},
{
"key_as_string":"01/04 12:00",
"key":1396353600000,
"doc_count":43434,
"terms_agg":{
"buckets":[
{
"key":"name_4",
"doc_count":8772
},
{
"key":"name_2",
"doc_count":8759
},
{
"key":"name_0",
"doc_count":8703
},
{
"key":"name_3",
"doc_count":8671
},
{
"key":"name_1",
"doc_count":8529
}
]
}
},
{
"key_as_string":"01/04 13:00",
"key":1396357200000,
"doc_count":43322,
"terms_agg":{
"buckets":[
{
"key":"name_1",
"doc_count":8691
},
{
"key":"name_2",
"doc_count":8690
},
{
"key":"name_0",
"doc_count":8677
},
{
"key":"name_4",
"doc_count":8673
},
{
"key":"name_3",
"doc_count":8591
}
]
}
},
{
"key_as_string":"01/04 14:00",
"key":1396360800000,
"doc_count":43589,
"terms_agg":{
"buckets":[
{
"key":"name_1",
"doc_count":8953
},
{
"key":"name_4",
"doc_count":8717
},
{
"key":"name_3",
"doc_count":8685
},
{
"key":"name_0",
"doc_count":8671
},
{
"key":"name_2",
"doc_count":8563
}
]
}
},
{
"key_as_string":"01/04 15:00",
"key":1396364400000,
"doc_count":43512,
"terms_agg":{
"buckets":[
{
"key":"name_2",
"doc_count":8741
},
{
"key":"name_1",
"doc_count":8730
},
{
"key":"name_4",
"doc_count":8712
},
{
"key":"name_3",
"doc_count":8702
},
{
"key":"name_0",
"doc_count":8627
}
]
}
},
{
"key_as_string":"01/04 16:00",
"key":1396368000000,
"doc_count":43241,
"terms_agg":{
"buckets":[
{
"key":"name_0",
"doc_count":8753
},
{
"key":"name_2",
"doc_count":8697
},
{
"key":"name_1",
"doc_count":8695
},
{
"key":"name_4",
"doc_count":8606
},
{
"key":"name_3",
"doc_count":8490
}
]
}
},
{
"key_as_string":"01/04 17:00",
"key":1396371600000,
"doc_count":43643,
"terms_agg":{
"buckets":[
{
"key":"name_4",
"doc_count":8831
},
{
"key":"name_1",
"doc_count":8742
},
{
"key":"name_2",
"doc_count":8736
},
{
"key":"name_0",
"doc_count":8686
},
{
"key":"name_3",
"doc_count":8648
}
]
}
},
{
"key_as_string":"01/04 18:00",
"key":1396375200000,
"doc_count":43379,
"terms_agg":{
"buckets":[
{
"key":"name_3",
"doc_count":8808
},
{
"key":"name_4",
"doc_count":8719
},
{
"key":"name_1",
"doc_count":8645
},
{
"key":"name_2",
"doc_count":8617
},
{
"key":"name_0",
"doc_count":8590
}
]
}
},
{
"key_as_string":"01/04 19:00",
"key":1396378800000,
"doc_count":43641,
"terms_agg":{
"buckets":[
{
"key":"name_1",
"doc_count":8835
},
{
"key":"name_3",
"doc_count":8770
},
{
"key":"name_0",
"doc_count":8732
},
{
"key":"name_2",
"doc_count":8686
},
{
"key":"name_4",
"doc_count":8618
}
]
}
},
{
"key_as_string":"01/04 20:00",
"key":1396382400000,
"doc_count":43878,
"terms_agg":{
"buckets":[
{
"key":"name_1",
"doc_count":8923
},
{
"key":"name_0",
"doc_count":8826
},
{
"key":"name_3",
"doc_count":8760
},
{
"key":"name_4",
"doc_count":8719
},
{
"key":"name_2",
"doc_count":8650
}
]
}
},
{
"key_as_string":"01/04 21:00",
"key":1396386000000,
"doc_count":43722,
"terms_agg":{
"buckets":[
{
"key":"name_2",
"doc_count":8871
},
{
"key":"name_0",
"doc_count":8805
},
{
"key":"name_1",
"doc_count":8727
},
{
"key":"name_4",
"doc_count":8664
},
{
"key":"name_3",
"doc_count":8655
}
]
}
},
{
"key_as_string":"01/04 22:00",
"key":1396389600000,
"doc_count":43431,
"terms_agg":{
"buckets":[
{
"key":"name_2",
"doc_count":8762
},
{
"key":"name_3",
"doc_count":8728
},
{
"key":"name_4",
"doc_count":8718
},
{
"key":"name_1",
"doc_count":8640
},
{
"key":"name_0",
"doc_count":8583
}
]
}
}
]
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment