ES 支持类似如下查询需求吗？

This topic created in 2534 days ago, the information mentioned may be changed or developed.

数据结构如下:

{
        "_index" : "movies",
        "_type" : "doc",
        "_id" : "618",
        "_score" : 1.0,
        "_source" : {
          "movieid" : "480",
          "title" : "Jurassic Park (1993)",
          "genres" : "Action|Adventure|Sci-Fi|Thriller",
          "rownum" : 618
        }
      },
      {
        "_index" : "movies",
        "_type" : "doc",
        "_id" : "494",
        "_score" : 1.0,
        "_source" : {
          "movieid" : "356",
          "title" : "Forrest Gump (1994)",
          "genres" : "Comedy|Drama|Romance|War",
          "rownum" : 494
        }
      }

现在想按 title 中的年份查询每个年代电影个数占比. Jurassic Park (1993)与 Forrest Gump (1994)同属九十年代。

如果电影库中一共有 100 条电影记录，九十年代有 70 部，则九十年代占比 70%.

7 replies • 2019-06-06 16:06:40 +08:00