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

Eugene Koifman edited comment on HIVE-11994 at 8/26/16 2:09 AM:
----------------------------------------------------------------

This comment is wrong.  SHOW COMPACTIONS does show history so this ticket is 
about adding meta info.  
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-ShowCompactions
 is update with additional "state" values


was (Author: ekoifman):
This comment is wrong.  SHOW COMPACTIONS does show history so this ticket is 
about adding meta info.

> SHOW COMPACTIONS should include meta info about the job
> -------------------------------------------------------
>
>                 Key: HIVE-11994
>                 URL: https://issues.apache.org/jira/browse/HIVE-11994
>             Project: Hive
>          Issue Type: Improvement
>          Components: Metastore, Transactions
>    Affects Versions: 1.0.0
>            Reporter: Eugene Koifman
>
> Currently output of SHOW COMPACTIONS only has current information.
> it would very useful if it could retain the data for a configurable period of 
> time after the Cleaner handles the entry.  Perhaps the entry can go into 'h' 
> state for 'historical'.
> Such historical data can be used to drive alert generating logic.
> We can add a column with a JSON doc which can include various stats about the 
> job: number of delta files, size in MB, time taken.  Also can be useful to 
> collect job properties from Hadoop, such as RAM used for example.  
> All of this can enhance the type/quality of alerts.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to