Upgrade HIVE version

[#1]

Hi,

Where can I find an article on how should I upgrade an existing HIVE db from 1.x version to 2.x version?

Thanks,

Michael

[#2 · Accepted solution]

@Michael Belostoky

Do you have HDP or you just have downloaded HDFS and Hive from Apache's website?

If you are using individual Apache components, then you can download and upgrade Hive by following instructions on Hive Website. You will have to first upgrade Hive Metastore by running scripts to upgrade schema and then upgrade the Hive installation.

https://github.com/apache/hive

If you have HDP, then you have to upgrade HDP, not just Hive. Think about how Hortonworks provides value to it's customers. One of the main benefits that HDP customers get is that all individual Apache Hadoop Ecosystem projects are tested together and packaged in each HDP version. This ensures that Hive 1.x that's bundled in HDP x.x is thoroughly tested with every component it is expected to work with. So, Hive in each HDP version is tested with HDFS, HBase, Spark, Pig, Sqoop and other projects.

If you upgrade only Hive and nothing else then Hortonworks cannot support it because our support and engineering rely on all the integration testing that went into each supported release.

So, if you have HDP then the way to upgrade is to upgrade HDP.