Elastichsearch Aggregations

Anushank_Lal · April 14, 2016, 12:21pm

We have multiple hotels and each hotel has diffirent price for different date which is also device specific. Now, if user search for a date range(11-04-2016 to 13-04-2016) then we need to get:

Hotel sorted against thier aggregate prices for the given dates for each device type.

I had kept prices, availability & dates within nested objects. See gist below:

gist.github.com

https://gist.github.com/Anushank-lal/bc001c71452352de20bef9d2481a1b3e

Input Data

{
	"id": 1,
	"name": "Hotel 1",
	"domainname": "hotel1.com",
	"state": "Jakarta",
	"reddoorz_site_id": 2,
	"popular": 700,
	"city": "Sudirman",
	"status": true,
	"full_address": "Hotel 1, Jakarta, INDONESIA",

This file has been truncated. show original

Mapping

{
  "site": {
    "dynamic": "true",
    "properties": {
      "prices_and_availability": {
        "type": "nested",
        "properties": {
          "date": {
            "format": "strict_date_optional_time||epoch_millis",
            "type": "date"

This file has been truncated. show original

Search output

{
  "took" : 1,
  "timed_out" : false,
  "_shards" : {
    "total" : 1,
    "successful" : 1,
    "failed" : 0
  },
  "hits" : {
    "total" : 4,

This file has been truncated. show original

There are more than three files. show original

Please help.

Thanks
Anushank

colings86 · April 14, 2016, 12:53pm

This appears to be the same question as Elastichsearch Price Aggregations on multi Nested Objects. Please keep your questions on one thread and be patient when waiting for an answer (see https://www.elastic.co/community/codeofconduct for more information on the code of conduct for this forum, in this case the 'be patient' section).

colings86 · April 14, 2016, 1:10pm

This topic was automatically closed after 17 minutes. New replies are no longer allowed.