question Re: When Tez/MR is better for query execution? in Archives of Support Questions (Read Only)

When Tez/MR is better for query execution?

msabri — Thu, 10 Nov 2016 16:20:43 GMT

Hello,

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

Re: When Tez/MR is better for query execution?

Former Member — Thu, 10 Nov 2016 17:42:12 GMT

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.

Re: When Tez/MR is better for query execution?

sunile_manjee — Fri, 11 Nov 2016 11:00:46 GMT

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).

Re: When Tez/MR is better for query execution?

y2k_shubhamgupt — Mon, 04 Mar 2019 21:00:30 GMT

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