[jira] [Created] (HIVE-20287) Document the differences between managed and external tables

["Lars Francke (JIRA)" <ji...@apache.org>]

Lars Francke created HIVE-20287:
-----------------------------------

             Summary: Document the differences between managed and external tables
                 Key: HIVE-20287
                 URL: https://issues.apache.org/jira/browse/HIVE-20287
             Project: Hive
          Issue Type: Improvement
          Components: Documentation
            Reporter: Lars Francke
            Assignee: Lars Francke


We should document all the differences between managed and external tables. I need everyone's help for that though.

This is what I know:

* ARCHIVE/UNARCHIVE - DDLTask - Only works for managed tables
* TRUNCATE - DDLSemanticAnalyzer - Only works for managed tables
* MERGE/CONCATENATE - HiveRelOpMaterializationValidator - Only works for managed tables
* Constraints - DDLSemanticAnalyzer -  (NOT NULL, DEFAULT, CHECK, only RELY ist allowed)
* IMPORT - ImportSemanticAnalyzer - This has some wild restrictions I didn't follow for external tables
* Query Results Caching - https://issues.apache.org/jira/browse/HIVE-18513 SemanticAnalyzer
 
Hortonworks has extra documentation listing these things:
* Query cache
* Materialized views, except in a limited way
* Default statistics gathering
* Compute queries using statistics
* Automatic runtime filtering
* File merging after insert
 
It'd be great if someone (from Hortonworks or otherwise) could elaborate on those.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)