For me, I tried Hive 4-LLAP, with the following procedure.
Execute llap-service.sh. This produces a new directory: llappkg/
Update Yarnfile to remove "placement_policy"
Execute llappkg/run.sh, and this creates a new Yarn service "llapservice"
Start HiveServer2 and execute queries.
However, the is no documentation available on Hive-LLAP, so it's hard to tune parameters.
If you are using Hive on Tez and still interested in achieving the performance of Hive-LLAP wit ease, there is an alternative solution Hive on MR3. Please check out the blog that compares Hive 4 on Tez and Hive 4 on MR3 (along with Trino 468 and Spark 4.0.0-RC2).
https://mr3docs.datamonad.com/blog/2025-04-18-performance-evaluation-2.0