0

How to perform update/delete in materialized view

I have created an MV with complex logic involving large tables and aggregate functions. 

As part of a new request, I need to update/delete certain records as well as change column data type. 

How to achieve these 3 scenarios?

P.s: I am aware of workaround (creating a new base table and joining). Is there is anyway as easy as update/delete statement?

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Gautham -- once you have the data read into dataframes in your MV, you can do whatever you like with that dataframe (delete records, update records, etc.). When you save that dataframe, it will save with the updated or deleted records.

    Like 1
Like Follow
  • 4 mths agoLast active
  • 1Replies
  • 18Views
  • 2 Following

Product Announcement

Incorta 4.9 is now Generally Available (GA)!!!