{"action":"opened","issue":{"url":"https://api.github.com/repos/NLPchina/elasticsearch-sql/issues/118","labels_url":"https://api.github.com/repos/NLPchina/elasticsearch-sql/issues/118/labels{/name}","comments_url":"https://api.github.com/repos/NLPchina/elasticsearch-sql/issues/118/comments","events_url":"https://api.github.com/repos/NLPchina/elasticsearch-sql/issues/118/events","html_url":"https://github.com/NLPchina/elasticsearch-sql/issues/118","id":118749729,"number":118,"title":"about sum/avg nested fields","user":{"login":"tigerone1","id":1128164,"avatar_url":"https://avatars.githubusercontent.com/u/1128164?v=3","gravatar_id":"","url":"https://api.github.com/users/tigerone1","html_url":"https://github.com/tigerone1","followers_url":"https://api.github.com/users/tigerone1/followers","following_url":"https://api.github.com/users/tigerone1/following{/other_user}","gists_url":"https://api.github.com/users/tigerone1/gists{/gist_id}","starred_url":"https://api.github.com/users/tigerone1/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tigerone1/subscriptions","organizations_url":"https://api.github.com/users/tigerone1/orgs","repos_url":"https://api.github.com/users/tigerone1/repos","events_url":"https://api.github.com/users/tigerone1/events{/privacy}","received_events_url":"https://api.github.com/users/tigerone1/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-11-25T02:59:31Z","updated_at":"2015-11-25T02:59:31Z","closed_at":null,"body":"hi eliranmoyal,I have other question about nested,for example,there is an nested array object,like this\r\n\"comments\": [\r\n{\r\n\"name\": \"John Smith\",\r\n\"comment\": \"Great article\",\r\n\"age\": 28,\r\n\"stars\": 4,\r\n\"date\": \"2014-09-01\"\r\n}\r\n,\r\n{\r\n\"name\": \"Alice White\",\r\n\"comment\": \"More like this please\",\r\n\"age\": 31,\r\n\"stars\": 5,\r\n\"date\": \"2014-10-22\"\r\n}\r\n]\r\nI want to select sum(comments.age) * from index,how to do?"}}