[
https://issues.apache.org/jira/browse/HIVE-26563?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18038786#comment-18038786
]
Denys Kuzmenko commented on HIVE-26563:
---------------------------------------
[~rkirtir] why didn't you resolve the ticket?
btw, i think there is an issue with the fix:
{{hightestwriteid}} from {{show compactions}} is never populated
{code:java}
+---------------+----------+----------+-----------+--------+------------+-------------+-----------+----------------+----------------+-----------+---------------------------+---------------+----------------+--------------+-----------+--------+------------+----------------+------------------+
| compactionid | dbname | tabname | partname | type | state | workerhost |
workerid | enqueuetime | starttime | duration | hadoopjobid | errormessage |
initiatorhost | initiatorid | poolname | txnid | nexttxnid | committime |
hightestwriteid |
+---------------+----------+----------+-----------+--------+------------+-------------+-----------+----------------+----------------+-----------+---------------------------+---------------+----------------+--------------+-----------+--------+------------+----------------+------------------+
| 3 | default | acittbl | --- | MAJOR | succeeded | --- | --- | 1763366029786
| 1763366037363 | 7631 | job_local1983232234_0001 | --- | metastore | 88 |
default | 45 | 45 | 1763366043473 | ---{code}
{code:java}
metastore_db=# select "CC_HIGHEST_WRITE_ID" from "COMPLETED_COMPACTIONS";
CC_HIGHEST_WRITE_ID --------------------- 20 30 40{code}
> Add extra columns in Show Compactions output and sort the output
> ----------------------------------------------------------------
>
> Key: HIVE-26563
> URL: https://issues.apache.org/jira/browse/HIVE-26563
> Project: Hive
> Issue Type: Improvement
> Components: Transactions
> Affects Versions: 3.0.0
> Reporter: KIRTI RUGE
> Assignee: KIRTI RUGE
> Priority: Major
>
> SHOW COMPACTIONS need reformatting in below aspects:
> 1.Need to add all below columns
> host information, duration, next_txn_id, txn_id, commit_time,
> highest_write_id, cleaner start, tbl_properties
> 2. Sort the output in a way it should display a moist recent element at the
> start(either completed or in progress)
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
