liaofucheng123的博客

1.类似sql select sum(item.paymentAmount) from order_main main left join order_item item on main.id = item.main_id where item.sku in (100000047) group by orderItemList.cityName 2.es queryDSL 按理说子项一般不会用于存地址。但是使用主表的字段进行 group by main.cityName之后出不来数据。所以在子项进行了冗余字

ES nested 统计仅符合的子项 相似SQL select sum(item.sku_cnt) from table_main main left join table_item item on main.id = item.main_id where main.id in (4,5,6) and item.sku_id is not null; 2.ES queryDSL查询 { "size": 0, "query": { "bool": {

ES通过多个字段分组后count排序. 数据库SQL:select count(1) from table group by storeCode,productId order by count(1) desc; { "query": { "bool": { "must": [ { "exists": { "field": "storeCod