[jira] [Created] (TRAFODION-55) LP Blueprint: ddl-query-invalidation - Trafodion DDL will be able to invalidate objects from affected caches.

["Alice Chen (JIRA)" <ji...@apache.org>]

Alice Chen created TRAFODION-55:
-----------------------------------

             Summary: 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)