hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Shreepadma Venugopalan (JIRA)" <>
Subject [jira] [Commented] (HIVE-3917) Support fast operation for analyze command
Date Tue, 29 Jan 2013 00:23:13 GMT


Shreepadma Venugopalan commented on HIVE-3917:

[~gangtimliu]: Thanks for the clarification. If we add a flag to indicate stats is stale,
how will we distinguish between the case when the stats is really stale vs the case when some
stats have been updated from a noscan operation?
> Support fast operation for analyze command
> ------------------------------------------
>                 Key: HIVE-3917
>                 URL:
>             Project: Hive
>          Issue Type: Improvement
>          Components: Statistics
>    Affects Versions: 0.11.0
>            Reporter: Gang Tim Liu
>            Assignee: Gang Tim Liu
>         Attachments: HIVE-3917.patch.1
> hive supports analyze command to gather statistics from existing tables/partition
> It collects:
> 1. Number of Rows
> 2. Number of files
> 3. Size in Bytes
> If table/partition is big, the operation would take time since it will open all files
and scan all data.
> It would be nice to support fast operation to gather statistics which doesn't require
to open all files:
> 1. Number of files
> 2. Size in Bytes
> Potential syntax is 
> ANALYZE TABLE tablename [PARTITION(partcol1[=val1], partcol2[=val2], ...)] COMPUTE STATISTICS
> In the future, all statistics without scan can be retrieved via this optional parameter.

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see:

View raw message