Skip to main content

Reverse nested - ElasticSearch


GET app_default/review/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "match": {
            "entityId": "CitizenMLondonBankside"
          }
        },
        {
          "match": {
            "entityType": "Hotel"
          }
        },
        {
          "nested": {
            "path": "details",
            "query": {
              "range": {
                "details.date": {
                  "gte": "2012-07-13",
                  "lte": "2014-07-15"
                }
              }
            }
          }
        },
        {
          "nested": {
            "path": "facts",
            "query": {
              "match": {
                "facts.key": "room"
              }
            }
          }
        }
      ]
    }
  },
  "aggs": {
    "rating": {
      "nested": {
        "path": "details"
      },
      "aggs": {
        "avg_rating": {
          "date_histogram": {
            "field": "date",
            "interval": "month"
          },
          "aggs": {
            "avg_price": {
              "reverse_nested": {},
              "aggs": {
                "score_average": {
                  "nested": {
                    "path": "facts"
                  },
                  "aggs": {
                    "avg_rating": {
                      "filter": {
                        "query": {
                          "match": {
                            "facts.key": "room"
                          }
                        }
                      },
                      "aggs": {
                        "avg_price": {
                          "avg": {
                            "field": "facts.score"
                          }
                        }
                      }
                    }
                  }
                }
              }
            }
          }
        }
      }
    }
  }

}

Comments

Post a Comment

Popular posts from this blog

SVN to GIT Migration with revision history

This blog explains the process I have followed while moving one of code branch of one of the projects to Gitlab. SVN to Git migration can be done using the git-svn command in Git.  Documentation about this command can be found from here. https://git-scm.com/docs/git-svn My Company svn repository can be accessed using two ways svn+ssh://192.168.x.x/usr/local/ svnroot/branches/PROJECT/PROJECT_BRANCH http://svn.companyName.net/repos/svnroot/branches/ PROJECT/PROJECT_BRANCH SVN to GIT migration can be done using one of the above-mentioned URLs.  Git can be installed and configured to use its inbuilt SSH client or third party ssh client ( https://6xgate.github.io/TortoisePlink/ ) First of all, this process should be run in a server where the system does not go idle. I have tried this on my PC. But when I have locked the PC, it crashes. Therefore I have tried this in one of our internal server. I have tried to get SVN revision history when the P...
Post a Comment
Read more

Java 11 Modularity and Spring REST

I have recently started working on creating a REST API for a client project.  I was using Java 8 for my past developments. Since Java 11 was introduced in the last September  (https://en.wikipedia.org/wiki/Java_version_history) I thought of developing the REST API in Java 11. Java 11 is having major changes after Java 8. Java 11 is having a concept of modules (This was introduced after Java 9). Several libraries are acting as separate modules. Those are not included in JDK and those have to be imported separately. Ref : http://openjdk.java.net/jeps/261 (I have experienced this in JBoss7 also. They were using the module system and each service can specify which modules which are using. Those modules can be manually configured by the user.) One example is that you have to import the Java fx library separately (For GUI). Java-Fx is decoupled from JDK. <!-- https://mvnrepository.com/artifact/org.openjfx/javafx -->   ...
Post a Comment
Read more

President - Association of Computer Engineering Students

I was selected to be the president of ACES, Association of Computer Engineering Students, the official student body of the Department of Computer Engineering Students. ACES Site :  aces.ce.pdn.ac.lk  It was a great opportunity to work with fellow undergraduates, lecturers, senior graduates, and industry. Until now We were able to organize few events in University of Peradeniya and Colombo. This event was organized by ACES Council, a group of 14 undergraduates. The events are, ACES Hackathon - This is an inner hackathon for undergraduates in the University of Peradeniya. ACES Hackathon, held annually for the last 5 years was held from the 29th of April to the 1st of May 2016 at the Faculty of Engineering, University of Peradeniya. The Hackathon brings together undergraduates from the Faculty of Engineering and Science for 3 days to develop their creative skills to provide innovative IT solutions. This year there were 150+ participants.   www.readme.lk/saw-ac...
Post a Comment
Read more