Hi Team,
I have a query where I am joining with 10 other entities Like Select a.col1,b1.col1,b2.col1 from A a Left outer join b1 on Left outer join b2 on Left outer join b3…. A is my driver entity which a 20 million data. Most of the other entities are small just 10 to 20 rows of data. In that scenario, my hive query is taking hours of time to join and fetch it. Please suggest me optimization technique. This is chocking the query performance. *Regards,* *Himabindu Sanka*