# HIve on tez or Hive on Spark?

**URL:** <https://discuss.elastic.co/t/hive-on-tez-or-hive-on-spark/108388>\
**Category:** Elasticsearch\
**Tags:** es-hadoop\
**Created:** [November 20, 2017, 1:23pm UTC](https://discuss.elastic.co/t/hive-on-tez-or-hive-on-spark/108388 "2017-11-20T13:23:40Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sdavy](https://avatars.discourse-cdn.com/v4/letter/s/ebca7d/32.png) [@sdavy](https://discuss.elastic.co/u/sdavy)\
**Post date:** [November 20, 2017, 1:23pm UTC](https://discuss.elastic.co/t/hive-on-tez-or-hive-on-spark/108388/1 "2017-11-20T13:23:41Z")

</div>

Hello everybody,

I'm trying to play with Hive and Elastic. I've been able to deploy a basic Hive config and adding the elastic-hadoop-hive jars I can create an external table mapped on Hadoop. Now, I have some messages telling that using mr as execution engine will be deprecated. Then I understand that I should use tez or Spark.

Which one should I use? Tez seems a little bit complex to install (need to build from source using Maven), but people says that performances are better.

Does anyone have some opinion on this? What is the optimal setup for Hive on Elasticsearch?

Thanks a lot,

Stéphane

---

<div class="post-metadata">

**Author:** ![james.baiera](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/james.baiera/32/10209_2.png) [@james.baiera](https://discuss.elastic.co/u/james.baiera)\
**Post date:** [December 13, 2017, 6:01pm UTC](https://discuss.elastic.co/t/hive-on-tez-or-hive-on-spark/108388/2 "2017-12-13T18:01:27Z")

</div>

Elastic doesn't take an official standpoint on whether to use MR, Tez, or Spark for Hive's execution layer. We primarily test our Hive solution on a local distribution that is based on MR.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [January 10, 2018, 6:01pm UTC](https://discuss.elastic.co/t/hive-on-tez-or-hive-on-spark/108388/3 "2018-01-10T18:01:45Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.