[ 
https://issues.apache.org/jira/browse/HIVE-3958?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16307607#comment-16307607
 ] 

Lefty Leverenz commented on HIVE-3958:
--------------------------------------

Doc note:  This adds the syntax ANALYZE TABLE ... COMPUTE STATISTICS 
PARTIALSCAN, which needs to be documented in the wiki.  The reserved keyword 
PARTIALSCAN is already documented.

* [Statistics -- ExistingTables–ANALYZE | 
https://cwiki.apache.org/confluence/display/Hive/StatsDev#StatsDev-ExistingTables–ANALYZE]
* [DDL -- Reserved Keywords | 
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-ReservedKeywords]

HIVE-17652 removes this syntax in release 3.0.0.

Added a TODOC11 label.

> support partial scan for analyze command - RCFile
> -------------------------------------------------
>
>                 Key: HIVE-3958
>                 URL: https://issues.apache.org/jira/browse/HIVE-3958
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: Gang Tim Liu
>            Assignee: Gang Tim Liu
>              Labels: TODOC11
>             Fix For: 0.11.0
>
>         Attachments: HIVE-3958.patch.1, HIVE-3958.patch.2, HIVE-3958.patch.3, 
> HIVE-3958.patch.4, HIVE-3958.patch.5, HIVE-3958.patch.6
>
>
> analyze commands allows us to collect statistics on existing 
> tables/partitions. It works great but might be slow since it scans all files.
> There are 2 ways to speed it up:
> 1. collect stats without file scan. It may not collect all stats but good and 
> fast enough for use case. HIVE-3917 addresses it
> 2. collect stats via partial file scan. It doesn't scan all content of files 
> but part of it to get file metadata. some examples are 
> https://cwiki.apache.org/Hive/rcfilecat.html for RCFile, ORC ( HIVE-3874 ) 
> and HFile of Hbase (Edit:  That link should be 
> https://cwiki.apache.org/confluence/display/Hive/RCFileCat.)
> This jira is targeted to address the #2. More specifically RCFile format.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Reply via email to