[ https://issues.apache.org/jira/browse/HIVE-13353?focusedWorklogId=818819&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-818819 ]
ASF GitHub Bot logged work on HIVE-13353: ----------------------------------------- Author: ASF GitHub Bot Created on: 20/Oct/22 14:39 Start Date: 20/Oct/22 14:39 Worklog Time Spent: 10m Work Description: deniskuzZ commented on code in PR #3608: URL: https://github.com/apache/hive/pull/3608#discussion_r1000728500 ########## ql/src/java/org/apache/hadoop/hive/ql/ddl/process/show/compactions/ShowCompactionsAnalyzer.java: ########## @@ -40,20 +43,44 @@ public ShowCompactionsAnalyzer(QueryState queryState) throws SemanticException { @Override public void analyzeInternal(ASTNode root) throws SemanticException { + ctx.setResFile(ctx.getLocalTmpPath()); String poolName = null; - Tree pool = root.getChild(0); - if (pool != null) { - if (pool.getType() != HiveParser.TOK_COMPACT_POOL) { - throw new SemanticException("Unknown token, 'POOL' expected."); - } else { - poolName = unescapeSQLString(pool.getChild(0).getText()); + String dbName = null; + String tbName = null; + String compactionType = null; + String compactionStatus = null; + Map<String, String> partitionSpec = null; + if (root.getChildCount() > 6) { + throw new SemanticException(ErrorMsg.INVALID_AST_TREE.getMsg(root.toStringTree())); + } + if (root.getType() == HiveParser.TOK_SHOW_COMPACTIONS && root.getChildCount() >= 1) { Review Comment: no need for `root.getChildCount() >= 1` check ########## ql/src/java/org/apache/hadoop/hive/ql/ddl/process/show/compactions/ShowCompactionsAnalyzer.java: ########## @@ -40,20 +43,44 @@ public ShowCompactionsAnalyzer(QueryState queryState) throws SemanticException { @Override public void analyzeInternal(ASTNode root) throws SemanticException { + ctx.setResFile(ctx.getLocalTmpPath()); String poolName = null; - Tree pool = root.getChild(0); - if (pool != null) { - if (pool.getType() != HiveParser.TOK_COMPACT_POOL) { - throw new SemanticException("Unknown token, 'POOL' expected."); - } else { - poolName = unescapeSQLString(pool.getChild(0).getText()); + String dbName = null; + String tbName = null; + String compactionType = null; + String compactionStatus = null; + Map<String, String> partitionSpec = null; + if (root.getChildCount() > 6) { + throw new SemanticException(ErrorMsg.INVALID_AST_TREE.getMsg(root.toStringTree())); + } + if (root.getType() == HiveParser.TOK_SHOW_COMPACTIONS && root.getChildCount() >= 1) { Review Comment: redundant `root.getChildCount() >= 1` check Issue Time Tracking ------------------- Worklog Id: (was: 818819) Time Spent: 5h 40m (was: 5.5h) > SHOW COMPACTIONS should support filtering options > ------------------------------------------------- > > Key: HIVE-13353 > URL: https://issues.apache.org/jira/browse/HIVE-13353 > Project: Hive > Issue Type: Improvement > Components: Transactions > Affects Versions: 1.3.0, 2.0.0 > Reporter: Eugene Koifman > Assignee: KIRTI RUGE > Priority: Major > Labels: pull-request-available > Attachments: HIVE-13353.01.patch > > Time Spent: 5h 40m > Remaining Estimate: 0h > > Since we now have historical information in SHOW COMPACTIONS the output can > easily become unwieldy. (e.g. 1000 partitions with 3 lines of history each) > this is a significant usability issue > Need to add ability to filter by db/table/partition > Perhaps would also be useful to filter by status -- This message was sent by Atlassian Jira (v8.20.10#820010)