The following is my attempt at operation 1.execute "ALTER TABLE test.a PARTITION(datets='2025-05-06') COMPACT 'MAJOR'" on my transaction table,and I can confirm that compact execute successfully by executing "SHOW COMPACTIONS" 2.execute "distcp" copy data which has been compact to the other HDFS 3.create new table on the HDFS location, and execute "msck repair table test.a" But In the end, I couldn't find the data.
By the way, I have one other question, how to migrate transaction table to normal orc table(with no acid but stored as orc format) 243776...@qq.com
