{"action":"created","issue":{"url":"https://api.github.com/repos/yandex/ClickHouse/issues/2942","repository_url":"https://api.github.com/repos/yandex/ClickHouse","labels_url":"https://api.github.com/repos/yandex/ClickHouse/issues/2942/labels{/name}","comments_url":"https://api.github.com/repos/yandex/ClickHouse/issues/2942/comments","events_url":"https://api.github.com/repos/yandex/ClickHouse/issues/2942/events","html_url":"https://github.com/yandex/ClickHouse/pull/2942","id":353734401,"node_id":"MDExOlB1bGxSZXF1ZXN0MjEwNzA0OTE0","number":2942,"title":"Additional higher order functions to work with arrays","user":{"login":"astudnev","id":1385046,"node_id":"MDQ6VXNlcjEzODUwNDY=","avatar_url":"https://avatars2.githubusercontent.com/u/1385046?v=4","gravatar_id":"","url":"https://api.github.com/users/astudnev","html_url":"https://github.com/astudnev","followers_url":"https://api.github.com/users/astudnev/followers","following_url":"https://api.github.com/users/astudnev/following{/other_user}","gists_url":"https://api.github.com/users/astudnev/gists{/gist_id}","starred_url":"https://api.github.com/users/astudnev/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/astudnev/subscriptions","organizations_url":"https://api.github.com/users/astudnev/orgs","repos_url":"https://api.github.com/users/astudnev/repos","events_url":"https://api.github.com/users/astudnev/events{/privacy}","received_events_url":"https://api.github.com/users/astudnev/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"VadimPE","id":18518081,"node_id":"MDQ6VXNlcjE4NTE4MDgx","avatar_url":"https://avatars1.githubusercontent.com/u/18518081?v=4","gravatar_id":"","url":"https://api.github.com/users/VadimPE","html_url":"https://github.com/VadimPE","followers_url":"https://api.github.com/users/VadimPE/followers","following_url":"https://api.github.com/users/VadimPE/following{/other_user}","gists_url":"https://api.github.com/users/VadimPE/gists{/gist_id}","starred_url":"https://api.github.com/users/VadimPE/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/VadimPE/subscriptions","organizations_url":"https://api.github.com/users/VadimPE/orgs","repos_url":"https://api.github.com/users/VadimPE/repos","events_url":"https://api.github.com/users/VadimPE/events{/privacy}","received_events_url":"https://api.github.com/users/VadimPE/received_events","type":"User","site_admin":false},"assignees":[{"login":"VadimPE","id":18518081,"node_id":"MDQ6VXNlcjE4NTE4MDgx","avatar_url":"https://avatars1.githubusercontent.com/u/18518081?v=4","gravatar_id":"","url":"https://api.github.com/users/VadimPE","html_url":"https://github.com/VadimPE","followers_url":"https://api.github.com/users/VadimPE/followers","following_url":"https://api.github.com/users/VadimPE/following{/other_user}","gists_url":"https://api.github.com/users/VadimPE/gists{/gist_id}","starred_url":"https://api.github.com/users/VadimPE/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/VadimPE/subscriptions","organizations_url":"https://api.github.com/users/VadimPE/orgs","repos_url":"https://api.github.com/users/VadimPE/repos","events_url":"https://api.github.com/users/VadimPE/events{/privacy}","received_events_url":"https://api.github.com/users/VadimPE/received_events","type":"User","site_admin":false}],"milestone":null,"comments":1,"created_at":"2018-08-24T10:45:06Z","updated_at":"2018-08-31T13:35:32Z","closed_at":null,"author_association":"NONE","pull_request":{"url":"https://api.github.com/repos/yandex/ClickHouse/pulls/2942","html_url":"https://github.com/yandex/ClickHouse/pull/2942","diff_url":"https://github.com/yandex/ClickHouse/pull/2942.diff","patch_url":"https://github.com/yandex/ClickHouse/pull/2942.patch"},"body":"I hereby agree to the terms of the CLA available at: https://yandex.ru/legal/cla/?lang=en\r\n\r\nI added couple functions to work with arrays, as i found no way to implement the functionality using the provided array functions.\r\n\r\n1) cumulative sum with limit ( if acc value less than 0, zero is accumulated ). Ideal solution would be to implement a reduce function, which accepts 2 parameters - array and accumulating value, but i fail to program so far\r\n\r\n2)  difference between values in array. This could be implemented using mapArray and couple other functions, but this will be nice to do in one call\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/yandex/ClickHouse/issues/comments/417666021","html_url":"https://github.com/yandex/ClickHouse/pull/2942#issuecomment-417666021","issue_url":"https://api.github.com/repos/yandex/ClickHouse/issues/2942","id":417666021,"node_id":"MDEyOklzc3VlQ29tbWVudDQxNzY2NjAyMQ==","user":{"login":"VadimPE","id":18518081,"node_id":"MDQ6VXNlcjE4NTE4MDgx","avatar_url":"https://avatars1.githubusercontent.com/u/18518081?v=4","gravatar_id":"","url":"https://api.github.com/users/VadimPE","html_url":"https://github.com/VadimPE","followers_url":"https://api.github.com/users/VadimPE/followers","following_url":"https://api.github.com/users/VadimPE/following{/other_user}","gists_url":"https://api.github.com/users/VadimPE/gists{/gist_id}","starred_url":"https://api.github.com/users/VadimPE/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/VadimPE/subscriptions","organizations_url":"https://api.github.com/users/VadimPE/orgs","repos_url":"https://api.github.com/users/VadimPE/repos","events_url":"https://api.github.com/users/VadimPE/events{/privacy}","received_events_url":"https://api.github.com/users/VadimPE/received_events","type":"User","site_admin":false},"created_at":"2018-08-31T13:35:32Z","updated_at":"2018-08-31T13:35:32Z","author_association":"MEMBER","body":"#3009 Fix"}}
{"actor":{"display_login":"VadimPE"}}