{"action":"created","issue":{"url":"https://api.github.com/repos/confluentinc/ksql/issues/519","repository_url":"https://api.github.com/repos/confluentinc/ksql","labels_url":"https://api.github.com/repos/confluentinc/ksql/issues/519/labels{/name}","comments_url":"https://api.github.com/repos/confluentinc/ksql/issues/519/comments","events_url":"https://api.github.com/repos/confluentinc/ksql/issues/519/events","html_url":"https://github.com/confluentinc/ksql/issues/519","id":281215214,"number":519,"title":"Request Group By statements work with Scalar functions","user":{"login":"tomlinsonr","id":34462182,"avatar_url":"https://avatars2.githubusercontent.com/u/34462182?v=4","gravatar_id":"","url":"https://api.github.com/users/tomlinsonr","html_url":"https://github.com/tomlinsonr","followers_url":"https://api.github.com/users/tomlinsonr/followers","following_url":"https://api.github.com/users/tomlinsonr/following{/other_user}","gists_url":"https://api.github.com/users/tomlinsonr/gists{/gist_id}","starred_url":"https://api.github.com/users/tomlinsonr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tomlinsonr/subscriptions","organizations_url":"https://api.github.com/users/tomlinsonr/orgs","repos_url":"https://api.github.com/users/tomlinsonr/repos","events_url":"https://api.github.com/users/tomlinsonr/events{/privacy}","received_events_url":"https://api.github.com/users/tomlinsonr/received_events","type":"User","site_admin":false},"labels":[{"id":450919827,"url":"https://api.github.com/repos/confluentinc/ksql/labels/enhancement","name":"enhancement","color":"84b6eb","default":true}],"state":"open","locked":false,"assignee":{"login":"hjafarpour","id":16784742,"avatar_url":"https://avatars3.githubusercontent.com/u/16784742?v=4","gravatar_id":"","url":"https://api.github.com/users/hjafarpour","html_url":"https://github.com/hjafarpour","followers_url":"https://api.github.com/users/hjafarpour/followers","following_url":"https://api.github.com/users/hjafarpour/following{/other_user}","gists_url":"https://api.github.com/users/hjafarpour/gists{/gist_id}","starred_url":"https://api.github.com/users/hjafarpour/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hjafarpour/subscriptions","organizations_url":"https://api.github.com/users/hjafarpour/orgs","repos_url":"https://api.github.com/users/hjafarpour/repos","events_url":"https://api.github.com/users/hjafarpour/events{/privacy}","received_events_url":"https://api.github.com/users/hjafarpour/received_events","type":"User","site_admin":false},"assignees":[{"login":"hjafarpour","id":16784742,"avatar_url":"https://avatars3.githubusercontent.com/u/16784742?v=4","gravatar_id":"","url":"https://api.github.com/users/hjafarpour","html_url":"https://github.com/hjafarpour","followers_url":"https://api.github.com/users/hjafarpour/followers","following_url":"https://api.github.com/users/hjafarpour/following{/other_user}","gists_url":"https://api.github.com/users/hjafarpour/gists{/gist_id}","starred_url":"https://api.github.com/users/hjafarpour/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hjafarpour/subscriptions","organizations_url":"https://api.github.com/users/hjafarpour/orgs","repos_url":"https://api.github.com/users/hjafarpour/repos","events_url":"https://api.github.com/users/hjafarpour/events{/privacy}","received_events_url":"https://api.github.com/users/hjafarpour/received_events","type":"User","site_admin":false}],"milestone":null,"comments":5,"created_at":"2017-12-12T00:30:12Z","updated_at":"2018-03-21T14:22:00Z","closed_at":null,"author_association":"NONE","body":"The following query should work:\r\n```sql\r\nSELECT\r\n  TIMESTAMPTOSTRING(ROWTIME, 'yyyy'),\r\n  sum(1)\r\nFROM clickstream\r\nWINDOW TUMBLING (SIZE 5 SECONDS)\r\nGROUP BY TIMESTAMPTOSTRING(ROWTIME, 'yyyy');\r\n```\r\n\r\nCurrently, it fails with:\r\n```\r\nnull\r\nQuery terminated\r\n```"},"comment":{"url":"https://api.github.com/repos/confluentinc/ksql/issues/comments/374953976","html_url":"https://github.com/confluentinc/ksql/issues/519#issuecomment-374953976","issue_url":"https://api.github.com/repos/confluentinc/ksql/issues/519","id":374953976,"user":{"login":"tomlinsonr","id":34462182,"avatar_url":"https://avatars2.githubusercontent.com/u/34462182?v=4","gravatar_id":"","url":"https://api.github.com/users/tomlinsonr","html_url":"https://github.com/tomlinsonr","followers_url":"https://api.github.com/users/tomlinsonr/followers","following_url":"https://api.github.com/users/tomlinsonr/following{/other_user}","gists_url":"https://api.github.com/users/tomlinsonr/gists{/gist_id}","starred_url":"https://api.github.com/users/tomlinsonr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tomlinsonr/subscriptions","organizations_url":"https://api.github.com/users/tomlinsonr/orgs","repos_url":"https://api.github.com/users/tomlinsonr/repos","events_url":"https://api.github.com/users/tomlinsonr/events{/privacy}","received_events_url":"https://api.github.com/users/tomlinsonr/received_events","type":"User","site_admin":false},"created_at":"2018-03-21T14:21:59Z","updated_at":"2018-03-21T14:21:59Z","author_association":"NONE","body":"Time to bump this again.... cannot move forward with our KSQL project without this enhancement. This will also be the case for any BI company building on KSQL.\r\n\r\nCan I please get a call on if this is a priority and associated timeline?"}}
{"actor":{"display_login":"tomlinsonr"}}