{"action":"opened","issue":{"url":"https://api.github.com/repos/yandex/ClickHouse/issues/2078","repository_url":"https://api.github.com/repos/yandex/ClickHouse","labels_url":"https://api.github.com/repos/yandex/ClickHouse/issues/2078/labels{/name}","comments_url":"https://api.github.com/repos/yandex/ClickHouse/issues/2078/comments","events_url":"https://api.github.com/repos/yandex/ClickHouse/issues/2078/events","html_url":"https://github.com/yandex/ClickHouse/issues/2078","id":306739413,"number":2078,"title":"[Question] too large array size","user":{"login":"Jaxvk","id":20113411,"avatar_url":"https://avatars3.githubusercontent.com/u/20113411?v=4","gravatar_id":"","url":"https://api.github.com/users/Jaxvk","html_url":"https://github.com/Jaxvk","followers_url":"https://api.github.com/users/Jaxvk/followers","following_url":"https://api.github.com/users/Jaxvk/following{/other_user}","gists_url":"https://api.github.com/users/Jaxvk/gists{/gist_id}","starred_url":"https://api.github.com/users/Jaxvk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Jaxvk/subscriptions","organizations_url":"https://api.github.com/users/Jaxvk/orgs","repos_url":"https://api.github.com/users/Jaxvk/repos","events_url":"https://api.github.com/users/Jaxvk/events{/privacy}","received_events_url":"https://api.github.com/users/Jaxvk/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-03-20T06:03:48Z","updated_at":"2018-03-20T06:03:48Z","closed_at":null,"author_association":"NONE","body":"Hi, may someone can help me.\r\nwhen I test the `AggreateFunctionMergeTree`, met the error, here are the steps\r\n```\r\nDROP TABLE IF EXISTS test.stored_aggregates;\r\n\r\nCREATE TABLE test.stored_aggregates\r\n(\r\n\td\tDate,\r\n\tGroupArray\tAggregateFunction(groupArray, String)\r\n)\r\nENGINE = AggregatingMergeTree(d, (d), 8192);\r\n\r\nINSERT INTO test.stored_aggregates\r\nSELECT\r\n\ttoDate('2014-06-01') AS d,\r\n\tgroupArrayState(toString(number)) AS GroupArray\r\nFROM\r\n(\r\n\tSELECT * FROM system.numbers LIMIT 20000000\r\n)\r\nGROUP BY d\r\nORDER BY d;\r\n\r\n\r\nSELECT\r\n    d,\r\n    length(groupArrayMerge(GroupArray))\r\nFROM test.stored_aggregates\r\nGROUP BY d\r\nORDER BY d ASC;\r\n```"}}
{"actor":{"display_login":"Jaxvk"}}