Todd Lipcon created HIVE-21443:
----------------------------------
Summary: Better usability for SHOW COMPACTIONS
Key: HIVE-21443
URL: https://issues.apache.org/jira/browse/HIVE-21443
Project: Hive
Issue Type: Improvement
Components: Transactions
Reporter: Todd Lipcon
Currently on a test cluster the output of 'SHOW COMPACTIONS' has 117k rows.
This makes it basically useless to work with.
For better usability, we should support syntax like 'SHOW COMPACTIONS IN
<database>' or maybe 'SHOW COMPACTIONS ON <table>' (particular syntax to be
chosen for consistency with other operations I suppose).
Alternatively (or maybe in addition) it seems like it would be nice to expose
the same data in a queryable table (eg in information_schema or a system
namespace) so that I could do things like: SELECT dbname, state, count(*) from
compactions group by 1,2;
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
