As of September 2018, the analytics cluster is running Hive 1.1, but we in Product-Analytics are very much interested in a newer version of Hive so that we can access to a bunch of UDFs which are currently not available.
- substring_index (added in 2.0)
- MD5 (added in 2.0)
- SHA1 (added in 2.0)
When we met about it, @Nuria mentioned plans to upgrade to CDH6 from CDH5 once v6 leaves beta but informed us there's currently no release date and since v6 has been in beta long past Cloudera's ETA, AE has considered switching to Hortonworks as the distribution.
This ticket is to formally track the status of the upgrade :)