[
https://issues.apache.org/jira/browse/TRAFODION-55?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Suresh Subbiah closed TRAFODION-55.
-----------------------------------
> LP Blueprint: ddl-query-invalidation - Trafodion DDL will be able to
> invalidate objects from affected caches.
> -------------------------------------------------------------------------------------------------------------
>
> Key: TRAFODION-55
> URL: https://issues.apache.org/jira/browse/TRAFODION-55
> Project: Apache Trafodion
> Issue Type: New Feature
> Reporter: Apache Trafodion
> Assignee: Suresh Subbiah
>
> The Trafodion compiler and SQL runtime cache definitions of Trafodion tables,
> compiled queries using those tables, and HTableClient objects for them. This
> blueprint covers a new feature to invalidate these cached objects when
> certain DDL operations are performed on the corresponding Trafodion tables,
> indexes, constraints, views, etc.
> The following DDL operations are covered:
> drop table
> alter table add column
> alter table add check constraint
> alter table add unique constraint
> alter table add primary key
> alter table add foreign key (RI)
> create index
> drop column
> drop check constraint
> drop unique constraint
> drop primary key
> drop foreign key (RI)
> drop index
> These DDL operations not yet covered, but may be in version 1.0.
> drop view
> alter view
> drop schema cascade
> drop synonym
> sequence generator
> drop volatile tables
> others???
> These DDL operations are assumed to not need QI:
> create table
> create view
> drop schema (not cascade)
> ???
> These DDL operations that are not supported
> Non-trafodion objects (e.g., native HBase tables).
> Materialized Views
> Triggers
> Cache affected by QI:
> - NATable cache. This is directly visible with the NATableCacheEntries
> internal stored procedure, but only if not using the embedded compiler
> - Query cache, including text cache and hybrid query cache. This also is
> directly visible, using the QueryCacheEntries internal stored procedure, but
> only if not using the embedded compiler
> - Prepared, but not executing, queries Visible with the CQD
> AUTO_QUERY_RETRY_WARNINGS 'ON'
> - HTable cache (still to be done).
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
