Insert data into external mateview with using data in internal mateview cache

Solution Verified - Updated -

Issue

There is an external mateview which is based on internal mateview.
This query explained in the official document[1] does not the use cache in internal mateview.

insert into target_table select * from matview option nocache

How to use the cache in the internal mateview?

[1]
https://access.redhat.com/documentation/en-US/Red_Hat_JBoss_Data_Virtualization/6.2/html/Development_Guide_Volume_5_Caching_Guide/sect-External_Materialization.html#External_Materialization_Usage_Steps

Environment

  • Red Hat JBoss Data Virtualization
    • 6.x

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.