sql - Elasticsearch 查询过滤器

Question

我是 flex 搜索的新手。

如何将以下SQL语句转换为 flex 搜索查询？

select sum(totaldevicecount),datasource from
(select distinct oskey,custkey,productkey,
timekey,totaldevicecount,datasource from es_reporting_data_new) 
group by datasource;

谢谢

Answer 1

将查询简化到下面
select sum(totaldevicecount),datasource from es_reporting_data_new group by datasource;

ES查询将是

{
    "aggs": {
            "data_source": {
                "terms": {
                    "field": "datasource"
                },
                "aggs": {
                    "total_device_count": {
                        "sum": {
                            "field": "totaldevicecount"
                        }
                    }
                }
            }
        }
    }

有关更多详细信息，请参见 Elastic Search Sum aggregation with group by and where condition。