我正在使用elasticsearch。我需要elasticsearch的结果作为CSV文件。任何curl URL或任何插件来实现这一目标?
我已经使用cURL和jq(“ like sed,但对于JSON”)完成了此操作。例如,您可以执行以下操作以获取给定构面的前20个值的CSV输出:
sed
$ curl -X GET 'http://localhost:9200/myindex/item/_search?from=0&size=0' -d ' {"from": 0, "size": 0, "facets": { "sourceResource.subject.name": { "global": true, "terms": { "order": "count", "size": 20, "all_terms": true, "field": "sourceResource.subject.name.not_analyzed" } } }, "sort": [ { "_score": "desc" } ], "query": { "filtered": { "query": { "match_all": {} } } } }' | jq -r '.facets["subject"].terms[] | [.term, .count] | @csv' "United States",33755 "Charities--Massachusetts",8304 "Almshouses--Massachusetts--Tewksbury",8304 "Shields",4232 "Coat of arms",4214 "Springfield College",3422 "Men",3136 "Trees",3086 "Session Laws--Massachusetts",2668 "Baseball players",2543 "Animals",2527 "Books",2119 "Women",2004 "Landscape",1940 "Floral",1821 "Architecture, Domestic--Lowell (Mass)--History",1785 "Parks",1745 "Buildings",1730 "Houses",1611 "Snow",1579