{"action":"opened","issue":{"url":"https://api.github.com/repos/pilosa/pilosa/issues/1605","repository_url":"https://api.github.com/repos/pilosa/pilosa","labels_url":"https://api.github.com/repos/pilosa/pilosa/issues/1605/labels{/name}","comments_url":"https://api.github.com/repos/pilosa/pilosa/issues/1605/comments","events_url":"https://api.github.com/repos/pilosa/pilosa/issues/1605/events","html_url":"https://github.com/pilosa/pilosa/issues/1605","id":352102735,"node_id":"MDU6SXNzdWUzNTIxMDI3MzU=","number":1605,"title":"Is there the expression like sql \"select user_id from ad_log where day between 2018-08-01 and 2018-08-20 group by campaign_id having sum(impression)>10\"?","user":{"login":"zhyhang","id":5225836,"node_id":"MDQ6VXNlcjUyMjU4MzY=","avatar_url":"https://avatars3.githubusercontent.com/u/5225836?v=4","gravatar_id":"","url":"https://api.github.com/users/zhyhang","html_url":"https://github.com/zhyhang","followers_url":"https://api.github.com/users/zhyhang/followers","following_url":"https://api.github.com/users/zhyhang/following{/other_user}","gists_url":"https://api.github.com/users/zhyhang/gists{/gist_id}","starred_url":"https://api.github.com/users/zhyhang/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zhyhang/subscriptions","organizations_url":"https://api.github.com/users/zhyhang/orgs","repos_url":"https://api.github.com/users/zhyhang/repos","events_url":"https://api.github.com/users/zhyhang/events{/privacy}","received_events_url":"https://api.github.com/users/zhyhang/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-08-20T11:54:28Z","updated_at":"2018-08-20T11:54:28Z","closed_at":null,"author_association":"NONE","body":"Is there the expression like sql \"select user_id from ad_log where day between 2018-08-01 and 2018-08-20 group by campaign_id having sum(impression)>10\"?\r\n\r\nad_logs as index\r\nuser_id as column\r\ncampaign_id as row\r\ntime field? or int field? or combination?\r\n"}}
{"actor":{"display_login":"zhyhang"}}