Compaction works only on transactional table, and to make any table transactional it should meet following properties. Should be ORC Table Should be bucketed Should be managed table. Due you see the last point, you can't run compaction on non transactional table, if you do it from hive you will definitely get error, not sure from spark. ... View more