KIRTI RUGE created HIVE-29321:
---------------------------------
Summary: hightestwriteid from show compactions is never populated
Key: HIVE-29321
URL: https://issues.apache.org/jira/browse/HIVE-29321
Project: Hive
Issue Type: Bug
Reporter: KIRTI RUGE
{{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}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
