You can use jq to selectively pull JSON values, arrays, and objects from elasticsearch returns. It lets you filter out everything except the things you want and formats it decently as well. The syntax takes a bit of getting used to but once you get it the product makes working with JSON output much nicer.
http://stedolan.github.io/jq/ On Thursday, May 29, 2014 5:11:07 AM UTC-6, Сергей Шилов wrote: > > Hi all! > I use elasticsearch in a high-load project where an urgent need to save > traffic. > I have a some queries like this: > > curl -XGET > 'http://localhost:9200/testindex/testmapping/_search?pretty&scroll=5m' -d > '{"from":0, "size":1000}' > > { > "_scroll_id" : > "cXVlcnlUaGVuRmV0Y2g7MjszMjp6TmdjNmxkM1NtV1NOeTl5X3dab1FnOzMxOnpOZ2M2bGQzU21XU055OXlfd1pvUWc7MDs=", > "took" : 2, > "timed_out" : false, > "_shards" : { > "total" : 2, > "successful" : 2, > "failed" : 0 > }, > "hits" : { > "total" : 15457332, > "max_score" : 1.0, > "hits" : [ { > "_index" : "testindex", > "_type" : "testmapping", > "_id" : "mo7vQrWUTquBRowjq2AVkw", > "_score" : 1.0, "_source" : > {"reffer_id":"","date":"2013-05-31T00:00:00","source":5,"user_id":"2fdfdf0fbbce603cf24c0eee7dabf28c"} > }, ....] > } > } > > > Can I exclude some system fields (like _shards.*, hits._index, hits._type, > hits._id, hits._score)? I found how exclude source fields, but not system. > Also I need to get _timestamp field in _source rows. It generated from > 'date' field: > > '_timestamp' => array( > 'enabled' => true, > 'path' => 'date', > 'format' => "YYYY-MM-dd'T'HH:mm:ss" > ) > > > Thanks > -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/73a11577-11c9-4931-a0cd-a55bf36b8739%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
