Amazon Elastic MapReduce
Developer Guide (API Version 2009-03-31)
« PreviousNext »
View the PDF for this guide.Go to the AWS Discussion Forum for this product.Go to the Kindle Store to download this guide in Kindle format.Did this page help you?  Yes | No |  Tell us about it...

Upgrade to Hive 0.11.0

Hive 0.11.0 is an important upgrade that provides significant performance improvements, new features, and bug fixes. Notable updates in this version are:

  • Support for the ORC file format, a more efficient and high-performance way to store data in Hive.

  • Better Hive SQL flexibility with new windowing and analytics functions such as LEAD/LAG/FIRST/LAST and improvements to PARTITION BY and ORDER BY.

  • Better SQL compatibility with the introduction of decimal data type and TRUNCATE command.

  • JOIN optimizations are enhanced and the use of hints in JOINs is de-emphasized. (HIVE-3784)

  • Improvements to query plan optimization rules by removing redundant operators. (HIVE-948)

For a detailed list of new features, see Supported Hive Versions.

To use these improvements, you can either launch a new cluster on an AMI that supports Hive 0.11.0 or upgrade an older Hive cluster to Hive 0.11.0.

Note

Hadoop 1.0.3 (AMI 2.2.0 or later) does not support Hive 0.7 or Hive 0.5 and you must use Hive 0.8 or later.