Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

re-organize mat_views.tags_view to materialized views, tear down AnalyticsDB #3855

Closed
1 of 5 tasks
tx0c opened this issue Apr 2, 2024 · 1 comment · Fixed by #3860, #3914 or #3939
Closed
1 of 5 tasks

re-organize mat_views.tags_view to materialized views, tear down AnalyticsDB #3855

tx0c opened this issue Apr 2, 2024 · 1 comment · Fixed by #3860, #3914 or #3939
Assignees
@tx0c
Labels
delayed

Comments

@tx0c
Copy link
Contributor

tx0c commented Apr 2, 2024 •
edited by zeckli
Loading

Description

the mat_views.tags_view was implemented as daily view because of AnalyticsDB dependencies from EMR jobs;

since EMR jobs were teared down in Mid 2023, now we can re-implement these as materialized views;

  • mat_views.tags_view

  • mat_views.authors_view

  • mat_views.users_view

  • mat_views.circles_view

  • switch to the new created view

Story
@zeckli zeckli mentioned this issue Apr 3, 2024
Closed
tx0c pushed a commit that referenced this issue Apr 12, 2024
feat(tags-view-materialized): move mat_views.tags_view into db/migrat…
a2e4172 
…ions instead of AnalysisDB;

re-organize mat_views.tags_view to materialized views, tear down AnalyticsDB

resolves #3855
@tx0c tx0c mentioned this issue Apr 12, 2024
Merged
@zeckli zeckli mentioned this issue Apr 29, 2024
Open
@zeckli zeckli added the delayed label Apr 29, 2024
tx0c pushed a commit that referenced this issue May 14, 2024
feat(tags-view-materialized): move mat_views.tags_view into db/migrat…
66ab2a4 
…ions instead of AnalysisDB;

re-organize mat_views.tags_view to materialized views, tear down AnalyticsDB

resolves #3855
tx0c pushed a commit that referenced this issue May 14, 2024
feat(tags-view-materialized): move mat_views.tags_view into db/migrat…
c7817ec 
…ions instead of AnalysisDB;

re-organize mat_views.tags_view to materialized views, tear down AnalyticsDB

resolves #3855
tx0c pushed a commit that referenced this issue May 14, 2024
feat(tags-view-materialized): move mat_views.tags_view into db/migrat…
6d4e77c 
…ions instead of AnalysisDB;

re-organize mat_views.tags_view to materialized views, tear down AnalyticsDB

resolves #3855
tx0c pushed a commit that referenced this issue May 14, 2024
feat(tags-view-materialized): move mat_views.tags_view into db/migrat…
4a469d1 
…ions instead of AnalysisDB;

re-organize mat_views.tags_view to materialized views, tear down AnalyticsDB

resolves #3855
tx0c pushed a commit that referenced this issue May 14, 2024
feat(tags-view-materialized): move mat_views.tags_view into db/migrat…
d37aa18 
…ions instead of AnalysisDB;

re-organize mat_views.tags_view to materialized views, tear down AnalyticsDB

resolves #3855
tx0c pushed a commit that referenced this issue May 14, 2024
feat(tags-view-materialized): move mat_views.tags_view into db/migrat…
8e941b0 
…ions instead of AnalysisDB;

re-organize mat_views.tags_view to materialized views, tear down AnalyticsDB

resolves #3855
tx0c pushed a commit that referenced this issue May 14, 2024
feat(tags-view-materialized): move mat_views.tags_view into db/migrat…
2c87066 
…ions instead of AnalysisDB;

re-organize mat_views.tags_view to materialized views, tear down AnalyticsDB

resolves #3855
tx0c pushed a commit that referenced this issue May 14, 2024
feat(tags-view-materialized): move mat_views.tags_view into db/migrat…
9b177bd 
…ions instead of AnalysisDB;

re-organize mat_views.tags_view to materialized views, tear down AnalyticsDB

resolves #3855
tx0c pushed a commit that referenced this issue May 14, 2024
feat(tags-view-materialized): move mat_views.tags_view into db/migrat…
535b037 
…ions instead of AnalysisDB;

re-organize mat_views.tags_view to materialized views, tear down AnalyticsDB

resolves #3855
@tx0c tx0c closed this as completed in 37b977c May 14, 2024
@zeckli zeckli reopened this May 15, 2024
tx0c pushed a commit that referenced this issue May 15, 2024
feat(tags-view-materialized): move mat_views.tags_view into db/migrat…
0d32ac2 
…ions instead of AnalysisDB;

re-organize mat_views.tags_view to materialized views, tear down AnalyticsDB

resolves #3855
@zeckli
Copy link
Contributor

zeckli commented May 15, 2024

Still have to switch

tx0c pushed a commit that referenced this issue May 15, 2024
feat(tags-view-materialized): move mat_views.tags_view into db/migrat…
c06f984 
…ions instead of AnalysisDB;

re-organize mat_views.tags_view to materialized views, tear down AnalyticsDB

resolves #3855
@tx0c tx0c mentioned this issue May 15, 2024
Merged
tx0c pushed a commit that referenced this issue May 15, 2024
feat(tags-view-materialized): move mat_views.tags_view into db/migrat…
64e1a4b 
…ions instead of AnalysisDB;

re-organize mat_views.tags_view to materialized views, tear down AnalyticsDB

resolves #3855
tx0c pushed a commit that referenced this issue May 17, 2024
feat(tags-view-materialized): move mat_views.tags_view into db/migrat…
b439e2e 
…ions instead of AnalysisDB;

re-organize mat_views.tags_view to materialized views, tear down AnalyticsDB

resolves #3855
@tx0c tx0c closed this as completed in e76f31c May 21, 2024
tx0c pushed a commit that referenced this issue May 22, 2024
feat(tags-view-materialized): move mat_views.tags_view into db/migrat…
971acf0 
…ions instead of AnalysisDB;

add restricted authors exclusion from recent rollup (r3m, r1m, r2w, r1w)

re-organize mat_views.tags_view to materialized views, tear down AnalyticsDB

resolves #3855
@tx0c tx0c mentioned this issue May 22, 2024
Merged
tx0c pushed a commit that referenced this issue May 22, 2024
hotfix(tags-view-materialized): move mat_views.tags_view into db/migr…
9f354e9 
…ations instead of AnalysisDB;

add restricted authors exclusion from recent rollup (r3m, r1m, r2w, r1w)

re-organize mat_views.tags_view to materialized views, tear down AnalyticsDB

resolves #3855
@tx0c tx0c mentioned this issue May 22, 2024
Merged
@robertu7 robertu7 mentioned this issue Jun 17, 2024
Closed
3 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@tx0c tx0c

Labels
delayed
Projects
None yet
Milestone
No milestone
2 participants
@zeckli @tx0c