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 <[email protected]> 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!!
