NLPchina/elasticsearch-sql

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

Opened this issue · 1 comments

这里预期应该会返回一条带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"
      }
    }
  }
}

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