When Tez/MR is better for query execution?

[#1]

Hello,

I'm wondering when should we use Tez or MR as an execution engine for our queries running in hive?

[#2 · Accepted solution]

@msabri

Slide 9 and later from the following link can give more details: http://www.slideshare.net/Hadoop_Summit/w-235phall1pandey As one of the advantage of Tez is that it avoids multiple writes to HDFS which definitely improves overall performance.

[#3]

I would say as the latest release of HDP, I see very little to any reason to use MR over Tez. I would say default to tez and use MR if and when required (not may use cases).

[#4]

This is a fine answer that lists other aspects of considering Tez over MR for Hive
http://community.hortonworks.com/answers/83488/view.html