I don't get it. The transaction id in the error message "No delta files or original files found to compact in hdfs://... with min Open txnid:6704143" is related to a current transaction (transaction + lock) for another user, another database and table. But still it blocks the compaction for the current database/table
On 2020/06/01 20:13:08, David Morin <morin.david....@gmail.com> wrote: > Hi, > > I have a compaction issue on my cluster. When I force a compaction (major) on > one table I get this error in Metastore logs: > > 2020-06-01 19:49:35,512 ERROR [XXXX-78]: compactor.CompactorMR > (CompactorMR.java:run(264)) - No delta files or original files found to > compact in hdfs://...hive/warehouse/my.db/test for compactionId=57944651 with > min Open txnid:6704143. Compaction cannot compact above this txnid > > Any idea about the root cause and how to fix it ? > thx > > Current env: HDP 2.6.5 > Hive table in transactional mode (ORC) >
