{"action":"created","issue":{"url":"https://api.github.com/repos/citusdata/citus/issues/571","repository_url":"https://api.github.com/repos/citusdata/citus","labels_url":"https://api.github.com/repos/citusdata/citus/issues/571/labels{/name}","comments_url":"https://api.github.com/repos/citusdata/citus/issues/571/comments","events_url":"https://api.github.com/repos/citusdata/citus/issues/571/events","html_url":"https://github.com/citusdata/citus/issues/571","id":157970343,"number":571,"title":"Feature request: json_agg support","user":{"login":"rickyspeak","id":6101061,"avatar_url":"https://avatars.githubusercontent.com/u/6101061?v=3","gravatar_id":"","url":"https://api.github.com/users/rickyspeak","html_url":"https://github.com/rickyspeak","followers_url":"https://api.github.com/users/rickyspeak/followers","following_url":"https://api.github.com/users/rickyspeak/following{/other_user}","gists_url":"https://api.github.com/users/rickyspeak/gists{/gist_id}","starred_url":"https://api.github.com/users/rickyspeak/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rickyspeak/subscriptions","organizations_url":"https://api.github.com/users/rickyspeak/orgs","repos_url":"https://api.github.com/users/rickyspeak/repos","events_url":"https://api.github.com/users/rickyspeak/events{/privacy}","received_events_url":"https://api.github.com/users/rickyspeak/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/citusdata/citus/labels/needs%20review","name":"needs review","color":"eeeeee"}],"state":"open","locked":false,"assignee":{"login":"marcocitus","id":7127240,"avatar_url":"https://avatars.githubusercontent.com/u/7127240?v=3","gravatar_id":"","url":"https://api.github.com/users/marcocitus","html_url":"https://github.com/marcocitus","followers_url":"https://api.github.com/users/marcocitus/followers","following_url":"https://api.github.com/users/marcocitus/following{/other_user}","gists_url":"https://api.github.com/users/marcocitus/gists{/gist_id}","starred_url":"https://api.github.com/users/marcocitus/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/marcocitus/subscriptions","organizations_url":"https://api.github.com/users/marcocitus/orgs","repos_url":"https://api.github.com/users/marcocitus/repos","events_url":"https://api.github.com/users/marcocitus/events{/privacy}","received_events_url":"https://api.github.com/users/marcocitus/received_events","type":"User","site_admin":false},"assignees":[{"login":"marcocitus","id":7127240,"avatar_url":"https://avatars.githubusercontent.com/u/7127240?v=3","gravatar_id":"","url":"https://api.github.com/users/marcocitus","html_url":"https://github.com/marcocitus","followers_url":"https://api.github.com/users/marcocitus/followers","following_url":"https://api.github.com/users/marcocitus/following{/other_user}","gists_url":"https://api.github.com/users/marcocitus/gists{/gist_id}","starred_url":"https://api.github.com/users/marcocitus/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/marcocitus/subscriptions","organizations_url":"https://api.github.com/users/marcocitus/orgs","repos_url":"https://api.github.com/users/marcocitus/repos","events_url":"https://api.github.com/users/marcocitus/events{/privacy}","received_events_url":"https://api.github.com/users/marcocitus/received_events","type":"User","site_admin":false}],"milestone":null,"comments":8,"created_at":"2016-06-01T18:03:26Z","updated_at":"2016-07-07T20:35:06Z","closed_at":null,"body":"postgres=# select json_agg(event) from events group by (uid);\r\nERROR:  unsupported aggregate function json_agg\r\n\r\nFor our data model this feature is pretty critical. I hope this is a pretty easy to implement.\r\n\r\nEdit:  Forgot to mention that the shards are hash distributed on uid.  Though I doubt that matters very much for this issue."},"comment":{"url":"https://api.github.com/repos/citusdata/citus/issues/comments/231199127","html_url":"https://github.com/citusdata/citus/issues/571#issuecomment-231199127","issue_url":"https://api.github.com/repos/citusdata/citus/issues/571","id":231199127,"user":{"login":"ozgune","id":2545443,"avatar_url":"https://avatars.githubusercontent.com/u/2545443?v=3","gravatar_id":"","url":"https://api.github.com/users/ozgune","html_url":"https://github.com/ozgune","followers_url":"https://api.github.com/users/ozgune/followers","following_url":"https://api.github.com/users/ozgune/following{/other_user}","gists_url":"https://api.github.com/users/ozgune/gists{/gist_id}","starred_url":"https://api.github.com/users/ozgune/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ozgune/subscriptions","organizations_url":"https://api.github.com/users/ozgune/orgs","repos_url":"https://api.github.com/users/ozgune/repos","events_url":"https://api.github.com/users/ozgune/events{/privacy}","received_events_url":"https://api.github.com/users/ozgune/received_events","type":"User","site_admin":false},"created_at":"2016-07-07T20:35:05Z","updated_at":"2016-07-07T20:35:05Z","body":"@rickyspeak -- We're currently doing our product planning and I had a quick question about your use-case. This is in addition to @marcocitus and @lithp's notes.\r\n\r\nYou mentioned that you ingested 20-50K events/sec and that was one of the reasons for choosing ``INSERT`` over ``UPSERT``. We heard of a similar pattern multiple times before and tried to capture this in #509. If we had native support for #509, would you have considered using it?\r\n\r\nFor example, let's say you created two distributed tables, ``uid-event-raw`` and ``uid-event-upserted``. Both tables are hash distributed on ``uid`` and their shards are therefore co-located on the same machine. You'd insert raw events into ``uid-event-raw``, and roll them up through #509 or a trigger into ``uid-event-upserted``. What do you think?"}}
{"actor":{"display_login":"ozgune"}}