{"action":"opened","issue":{"url":"https://api.github.com/repos/NLPchina/elasticsearch-sql/issues/32","labels_url":"https://api.github.com/repos/NLPchina/elasticsearch-sql/issues/32/labels{/name}","comments_url":"https://api.github.com/repos/NLPchina/elasticsearch-sql/issues/32/comments","events_url":"https://api.github.com/repos/NLPchina/elasticsearch-sql/issues/32/events","html_url":"https://github.com/NLPchina/elasticsearch-sql/issues/32","id":53985083,"number":32,"title":"[enhancement] Add math functions","user":{"login":"daledude","id":590325,"avatar_url":"https://avatars.githubusercontent.com/u/590325?v=3","gravatar_id":"","url":"https://api.github.com/users/daledude","html_url":"https://github.com/daledude","followers_url":"https://api.github.com/users/daledude/followers","following_url":"https://api.github.com/users/daledude/following{/other_user}","gists_url":"https://api.github.com/users/daledude/gists{/gist_id}","starred_url":"https://api.github.com/users/daledude/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/daledude/subscriptions","organizations_url":"https://api.github.com/users/daledude/orgs","repos_url":"https://api.github.com/users/daledude/repos","events_url":"https://api.github.com/users/daledude/events{/privacy}","received_events_url":"https://api.github.com/users/daledude/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-01-11T07:50:02Z","updated_at":"2015-01-11T07:50:02Z","closed_at":null,"body":"It would be useful to have functions similar to mysql such as round, concat, substr, ceil, etc.\r\n\r\n```\r\nselect ROUND(sum(billedamount),5) as billedamt, max(id) as maxid from table;\r\n\r\nselect CONCAT(someField,'some text') as someData from table order by LENGTH(someData) desc;\r\n```"}}