hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lars Francke (JIRA)" <j...@apache.org>
Subject [jira] [Assigned] (HIVE-20287) Document the differences between managed and external tables
Date Wed, 01 Aug 2018 10:16:00 GMT

     [ https://issues.apache.org/jira/browse/HIVE-20287?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Lars Francke reassigned HIVE-20287:
-----------------------------------


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

Mime
View raw message