[
https://issues.apache.org/jira/browse/HIVE-29321?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
KIRTI RUGE resolved HIVE-29321.
-------------------------------
Fix Version/s: 4.0.0-beta-1
Resolution: Fixed
> hightestwriteid from show compactions is never populated
> --------------------------------------------------------
>
> Key: HIVE-29321
> URL: https://issues.apache.org/jira/browse/HIVE-29321
> Project: Hive
> Issue Type: Bug
> Affects Versions: 4.0.0-beta-1
> Reporter: KIRTI RUGE
> Priority: Major
> Fix For: 4.0.0-beta-1
>
>
> {{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)