Hello Hive users, I have published a new blog article 'Performance Tuning for Single-table Queries'. It shows how to change configuration parameters of Hive and Tez in order to make simple queries run faster than Spark. Although it uses Hive on MR3, the technique equally applies to Hive on Tez and Hive-LLAP.
https://www.datamonad.com/post/2023-12-23-optimize-bi-1.8/ Hope you find it useful. Cheers, --- Sungwoo
