{"action":"opened","issue":{"url":"https://api.github.com/repos/pipelinedb/pipelinedb/issues/1883","repository_url":"https://api.github.com/repos/pipelinedb/pipelinedb","labels_url":"https://api.github.com/repos/pipelinedb/pipelinedb/issues/1883/labels{/name}","comments_url":"https://api.github.com/repos/pipelinedb/pipelinedb/issues/1883/comments","events_url":"https://api.github.com/repos/pipelinedb/pipelinedb/issues/1883/events","html_url":"https://github.com/pipelinedb/pipelinedb/issues/1883","id":268011532,"number":1883,"title":"Change the definition of a continous view","user":{"login":"fritzrichter","id":3641931,"avatar_url":"https://avatars2.githubusercontent.com/u/3641931?v=4","gravatar_id":"","url":"https://api.github.com/users/fritzrichter","html_url":"https://github.com/fritzrichter","followers_url":"https://api.github.com/users/fritzrichter/followers","following_url":"https://api.github.com/users/fritzrichter/following{/other_user}","gists_url":"https://api.github.com/users/fritzrichter/gists{/gist_id}","starred_url":"https://api.github.com/users/fritzrichter/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fritzrichter/subscriptions","organizations_url":"https://api.github.com/users/fritzrichter/orgs","repos_url":"https://api.github.com/users/fritzrichter/repos","events_url":"https://api.github.com/users/fritzrichter/events{/privacy}","received_events_url":"https://api.github.com/users/fritzrichter/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2017-10-24T12:26:37Z","updated_at":"2017-10-24T12:26:37Z","closed_at":null,"author_association":"NONE","body":"Hey there,\r\nI am wondering how I can do the following without loosing the data:\r\n\r\n**BEFORE**\r\n`CREATE CONTINUOUS VIEW impressions_daily AS\r\nSELECT\r\ndate_trunc('day', impression_time) AS day,\r\naudience_id,\r\ndsp_id,\r\nCOUNT(*) AS total_impressions,\r\nCOUNT(DISTINCT ifa) AS unique_users\r\nFROM impression_stream\r\nGROUP BY audience_id, dsp_id, day;`\r\n\r\n**AFTER**\r\n`CREATE CONTINUOUS VIEW impressions_daily AS\r\nSELECT\r\ndate_trunc('day', impression_time) AS day,\r\naudience_id,\r\ndsp_id,\r\nCOUNT(*) AS total_impressions,\r\nCOUNT(DISTINCT ifa) AS unique_users\r\nFROM impression_stream\r\nWHERE platform_id IS NULL\r\nGROUP BY audience_id, dsp_id, day;`\r\n\r\nIs there a way to ALTER or change the view, as I want to add a new WHERE expression."}}
{"actor":{"display_login":"fritzrichter"}}