{"action":"created","issue":{"url":"https://api.github.com/repos/airbnb/caravel/issues/1203","repository_url":"https://api.github.com/repos/airbnb/caravel","labels_url":"https://api.github.com/repos/airbnb/caravel/issues/1203/labels{/name}","comments_url":"https://api.github.com/repos/airbnb/caravel/issues/1203/comments","events_url":"https://api.github.com/repos/airbnb/caravel/issues/1203/events","html_url":"https://github.com/airbnb/caravel/issues/1203","id":179536529,"number":1203,"title":"Add Slice support for arbitrary queries (including parameterization)","user":{"login":"Jparks2532","id":7040714,"avatar_url":"https://avatars.githubusercontent.com/u/7040714?v=3","gravatar_id":"","url":"https://api.github.com/users/Jparks2532","html_url":"https://github.com/Jparks2532","followers_url":"https://api.github.com/users/Jparks2532/followers","following_url":"https://api.github.com/users/Jparks2532/following{/other_user}","gists_url":"https://api.github.com/users/Jparks2532/gists{/gist_id}","starred_url":"https://api.github.com/users/Jparks2532/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Jparks2532/subscriptions","organizations_url":"https://api.github.com/users/Jparks2532/orgs","repos_url":"https://api.github.com/users/Jparks2532/repos","events_url":"https://api.github.com/users/Jparks2532/events{/privacy}","received_events_url":"https://api.github.com/users/Jparks2532/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/airbnb/caravel/labels/feature","name":"feature","color":"84b6eb"}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-09-27T16:00:12Z","updated_at":"2016-09-28T17:00:03Z","closed_at":null,"body":"Slice support for arbitrary queries (including parameterization) would enable all types of use cases where a materialized table or view doesn't quite work.  For instance, the following query template could serve as the source for a Slice:\r\n\r\nquery:\r\n```\r\nSELECT\r\n    dim,\r\n    SUM(cnt) AS first_moment\r\n    SUM(cnt*cnt) AS second_moment\r\nFROM (\r\n    SELECT id_user, <dimension1> AS dim, COUNT(*) cnt\r\n    FROM table1\r\n    WHERE ds between '<date_start>' and '<date_end>'\r\n    GROUP BY id_user, <dimension1> \r\n) t\r\nGROUP BY dim;\r\n```\r\n\r\nUsers could pass in parameters at query time.\r\n\r\n```\r\ndate_start: date\r\ndate_end: date\r\ndimension1: string\r\n```"},"comment":{"url":"https://api.github.com/repos/airbnb/caravel/issues/comments/250229471","html_url":"https://github.com/airbnb/caravel/issues/1203#issuecomment-250229471","issue_url":"https://api.github.com/repos/airbnb/caravel/issues/1203","id":250229471,"user":{"login":"yejianye","id":58540,"avatar_url":"https://avatars.githubusercontent.com/u/58540?v=3","gravatar_id":"","url":"https://api.github.com/users/yejianye","html_url":"https://github.com/yejianye","followers_url":"https://api.github.com/users/yejianye/followers","following_url":"https://api.github.com/users/yejianye/following{/other_user}","gists_url":"https://api.github.com/users/yejianye/gists{/gist_id}","starred_url":"https://api.github.com/users/yejianye/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yejianye/subscriptions","organizations_url":"https://api.github.com/users/yejianye/orgs","repos_url":"https://api.github.com/users/yejianye/repos","events_url":"https://api.github.com/users/yejianye/events{/privacy}","received_events_url":"https://api.github.com/users/yejianye/received_events","type":"User","site_admin":false},"created_at":"2016-09-28T17:00:03Z","updated_at":"2016-09-28T17:00:03Z","body":"Very interesting idea, how will that work with 'group by', 'metrics' parameters in various viz types?"}}
{"actor":{"display_login":"yejianye"}}