Hive Table query optimization

Hi Team,

We are joining multiple hive tables together and these tables are backed by parquet data. Still we see it is not performing great. Could you please advise how we can tune hive queries to run optimally apart from hive table statistics?

Thank you

Hi @Nagaraj_Malaiappan

Would you be able to send us the profile for one of these jobs?

Share a Query Profile

@balaji.ramaswamy (209.6 KB)

Hi Balaji,

Have uploaded the profile, please suggest optimization avenues