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