The SQL Processing engine of hive
SQL query are converted to a physical operator tree which is optimized and converted to the underlining engine via the calcite engine.
Most of the existing query optimizations in Hive are about minimizing shuffling cost.
set hive.execution.engine='mr';