Navigating Challenges on Hive: Unveiling Effective Solutions