用SQL語句查詢elasticsearch
來自： http://blog.csdn.net//jiao_fuyou/article/details/50556602
以前我是這樣查詢elasticsearch的：
POST /cdr*/hj_scpcdr/_search
{
"from" : 0,
"size" : 0,
"_source" : {
"includes" : [ "filedate", "vestss", "permark", "subpp", "SUM" ],
"excludes" : [ ]
},
"fields" : [ "filedate", "vestss", "permark", "subpp" ],
"sort" : [ {
"filedate" : {
"order" : "asc"
}
}, {
"vestss" : {
"order" : "asc"
}
}, {
"permark" : {
"order" : "asc"
}
}, {
"subpp" : {
"order" : "asc"
}
} ],
"aggregations" : {
"filedate" : {
"terms" : {
"field" : "filedate",
"size" : 200,
"order" : {
"_term" : "asc"
}
},
"aggregations" : {
"vestss" : {
"terms" : {
"field" : "vestss",
"size" : 0,
"order" : {
"_term" : "asc"
}
},
"aggregations" : {
"permark" : {
"terms" : {
"field" : "permark",
"size" : 0,
"order" : {
"_term" : "asc"
}
},
"aggregations" : {
"subpp" : {
"terms" : {
"field" : "subpp",
"size" : 0,
"order" : {
"_term" : "asc"
}
},
"aggregations" : {
"SUM(calldura60)" : {
"sum" : {
"field" : "calldura60"
}
}
}
}
}
}
}
}
}
}
}
}
但是我現在可以這樣查詢ES了：
POST /_sql select filedate,vestss,permark,subpp,sum(calldura60) from cdr*/hj_scpcdr group by filedate,vestss,permark,subpp order by filedate,vestss,permark,subpp
沒錯，安裝elasticsearch-sql插件就行了
https://github.com/NLPchina/elasticsearch-sql
本文由用戶 zjsrg 自行上傳分享，僅供網友學習交流。所有權歸原作者，若您的權利被侵害，請聯系管理員。
轉載本站原創文章，請注明出處，并保留原始鏈接、圖片水印。
本站是一個以用戶分享為主的開源技術平臺，歡迎各類分享！