[
https://issues.apache.org/jira/browse/HIVE-20287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16597318#comment-16597318
]
Lars Francke commented on HIVE-20287:
-------------------------------------
Thanks Eugene!
> 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
> Priority: Major
>
> 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)
