search

rakam-io / rakam-api

📈 Collect customer event data from your apps. (Note that this project only includes the API collector, not the visualization platform)
https://rakam.io
GNU Affero General Public License v3.0
798 stars 105 forks source link

Cannot update materialized view #66

Closed evelant closed 6 years ago

evelant commented 7 years ago

On some of my reports, they fail because rakam cannot update materialized view.

Error while updating materialized table '(SELECT * from taskhero."$materialized_segment_leavers" UNION ALL SELECT "id" FROM (SELECT * FROM taskhero."_users" WHERE "_time" > to_timestamp(1495476964)) data WHERE (("last_active_at" - interval '7 days') < "signup_date") ) data': ERROR: cannot change materialized view "$materialized_segment_leavers"
buremba commented 7 years ago

Hey Andrew, I sent you an e-mail. I need to investigate the issue more since I couldn't reproduce it on my local environment.

evelant commented 7 years ago

I didn't receive an email from you, maybe try to send again?

buremba commented 7 years ago

I sent the message via Intercom but it looks like their system only allows in-app messages. Now I re-sent the email from my email account.

buremba commented 6 years ago

Closing due to inactivity. Feel free to open if the issue is still not solved.