NLPchina / elasticsearch-sql

Use SQL to query Elasticsearch
Apache License 2.0
6.99k stars 1.54k forks source link

形如 SELECT count(*) as count ,avg(reg_cap) as avg,name FROM enterprise limit 1,limit 参数丢失 #1243

Open FuYouJ opened 6 months ago

FuYouJ commented 6 months ago

这里预期应该会返回一条带name字段的文档。 但是解析后的结果,limit 1因为聚合的原因,被抛弃了。

{
  "from": 0,
  "size": 0,
  "_source": {
    "includes": [
      "COUNT",
      "AVG",
      "name"
    ],
    "excludes": []
  },
  "stored_fields": "name",
  "aggregations": {
    "count": {
      "value_count": {
        "field": "_index"
      }
    },
    "avg": {
      "avg": {
        "field": "reg_cap"
      }
    }
  }
}
FuYouJ commented 6 months ago

在聚合里面,我们也会经常用到size参数吧。