[jira] [Created] (TRAFODION-1537) Improvements integrating Native tables with Trafodion's view of these tables

["Roberta Marton (JIRA)" <ji...@apache.org>]

Roberta Marton created TRAFODION-1537:
-----------------------------------------

             Summary: Improvements integrating Native tables with Trafodion's view of these tables
                 Key: TRAFODION-1537
                 URL: https://issues.apache.org/jira/browse/TRAFODION-1537
             Project: Apache Trafodion
          Issue Type: Improvement
          Components: sql-cmp
    Affects Versions: 1.2-incubating
            Reporter: Roberta Marton


In release 1.2, a new feature was added called external tables.  With this feature users can define native tables from Hive and HBase as external tables in Trafodion.  Based on the Trafodion definitions, additional SQL based operations can be performed.  For example, gathering statistics to create better plans.

The problem exists in keeping the Trafodion external table definition consistent the its native table counterpart. That is, when the native table definition changes, it should be reflected in the corresponding Trafodion external table. 

Today, when  we load an external table into cache, we check the native definition with the native table and report an mismatch. This check does an exact match - it needs to be relaxed a bit in order to allow subtle changes to exist.  Perhaps it should check for column placement and column names.

May want to design a bit more into how to best do consisteny checks. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)