hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jörn Franke <>
Subject Re: EMR 5.8 & Hue/Hive Performance/Stability Specifics
Date Tue, 12 Sep 2017 16:47:08 GMT
Test it, because it really depends what you do. Since you use hue you seem to be interested
in interactive analysis, so the best is to use Tez and llap as a hive engine. Make also sure
that you use ORC or Parquet as a Hive storage format. Leverage the in-build orc or parquet
indexes by sorting data on the filtering column. If possible partition the data.

I do not remember  at the moment if TEZ is included in the Hive package of EMR or if you have
to install an additional package. 
However, given your current Hive version you should see for sure an improvement.

> On 12. Sep 2017, at 18:41, Mr. Glenn Waldman <> wrote:
> Hi,
> We are upgrading our EMR from 4.7 - 5.8, along with Hue/Hive conjointly.  
> Hue: from 1.0 - 2.3
> Hive: to 3.12
> Can somebody explain some high-level, specific stability and performance increases we
should see from these upgrades?
> We run daily queries through Hue/Hive and are looking for how these upgrades should make
them run more quickly with less breaks.
> Thoughts!?
> Thanks!!

View raw message