Hive roadmap

As it is the end of this chapter as well as of this book, the highlight of each Hive release milestone and future features expected are summarized as follows along with best wishes to the Hive communities for growing bigger and better in the near future:

• December 2011 – Hive 0.8.0

  • Added Bitmap indexes

  • Added the TIMESTAMP data type

  • Added the Hive Plugin Developer Kit to make plugin building and testing easier

  • Improved JDBC Driver and bug fixes

• April 2012 – Hive 0.9.0

  • Added the CREATE OR REPLACE VIEW statement

  • Added NOT IN and NOT LIKE support

  • Added the BETWEEN and NULL safe equality operator

  • Added printf(), sort_array(), and concat_ws() functions

  • Added a filter push-down from Hive into HBase for the key column

  • Combined multiple UNION ALL statements in one MapReduce job

  • Combined multiple GROUP BY statements on the same data with the same keys in one MapReduce job

• January 2013 – Hive 0.10.0

  • Added the CUBE and ROLLUP statements

  • Added better support for YARN

  • Added more information in the EXPLAIN...