EDUCBA

EDUCBA

MENUMENU
  • Explore
    • Lifetime Membership
    • All in One Bundles
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign up
Home Data Science Data Science Tutorials Hive Tutorial Hive Versions

Hive Versions

Arpit Anand
Article byArpit Anand
Priya Pedamkar
Reviewed byPriya Pedamkar

Updated July 10, 2023

hive versions

Introduction to Hive Versions

Hive is the data warehousing tool built on top of Hadoop for data processing for large data sets. It was released in 2010 and is the most widely used ETL and data processing tool. After the release, Hive came over with many improvements and bug fixes with its versions upgraded. The latest stable release for Hive came in August 2019 that is in use. HIVE has undergone several updates, resulting in increased durability and improved functionality.

ADVERTISEMENT
Popular Course in this category
HIVE Course Bundle - 7 Courses in 1

Start Your Free Data Science Course

Hadoop, Data Science, Statistics & others

Top 7 Versions of Hive

The various ways of running a hive using these versions are described below.

1. Version 0.9.0

Hive version 0.9.0 fixed the bug for timestampWritable.java that was causing data corruption. This was the initial version with the release date as 3 Dec 2013. Map Reduce versions 2.x and 3.x introduced various new functionalities and resolved existing bugs. The get schema() function was not returning the correct schema for Explain queries. Hdfs were hard coded, which was the barrier to using other file systems. The Hive’s latest version included numerous bugs of this kind.

2. Version 0.10.0

This hive version fixed several noted issues as the release came sooner after the 0.9 version. The software had some problems with bugs that caused syntax errors, memory leakage, and null pointer replacement within nested UDFs. However, these bugs have been fixed in the updated version of Hive 0.10.

3. Version 0.11.0

They released a new version of Hive, known as version 0.10, in August 2014 to fix major bugs they encountered. This version includes a significant modification that will cause the server to go into a SHUTDOWN state if it executes any incorrect queries. Map joins were not giving the correct results; under java 7 hive compiler showed issues; these were the major bug handled in this version.

While mixing Avro and snappy null values was returned, this bug was also solved in this release. Also, inserting multiple overwrite into multiple tables stored the same results in all the tables handled in this release.

4. Version 0.12.0

This release for Hive added a new Data Type Date. This data type made inserting a date in the hive columns easy. The system now cleans up the contents in the scratch directories. We could define functions with HQL. The development team introduced the exchange partition functionality in the Hive version.

Spark SQL was introduced to work with HIVE; we can also use the Hive with HBASE. Format_number started supporting the decimal data type. In this release of the Hive, the development team resolved the bug that caused Hive to continuously retry deleting a lock even when Zookeeper responded that the node did not exist. As a result, Hive no longer attempts this operation unnecessarily. The Hive has introduced the Varchar data type and supports in-memory PTF transactions.

5. Version 0.13.0

Hive came upon another update over mid of 2014, adding some extra features to Hive’s functionalities and making it much stronger. This release introduced several additional features, including the char data type, subquery support, permanent UDFs, ORC file footer support, and improved hive precision. While creating or dropping a database, the permission was modified as the same, which can be done only by checking the user’s permission. It started skipping the Header and Footer rows while reading the data file. You can use an introduced UDF to calculate the distance between geographical coordinates.

Now parquet Text data was readable, and we could determine the version of the Hive we are using HIVE API or CLI. We can now submit multiple queries at a time separated by a; The decision for adjusting the mapper and reducer based on input file size was also available from this release version. They enabled secure mode and Kerberos when starting the Hive Meta store. Daylight savings were handled correctly.

6. Version 1.0.0

Hive came up with a new version with some improvements in performance and other features. We can connect to JDBC with a hive server using the SASL QOP parameter. Hive came with the property of (Hive.optimize.insert.dest.volume=true) that created the hive scratch directory in the same volume as the target table.

The handling of authentication support in this release was excellent. The Hive server accepted inbound authentication for MAPR SASL and PAM once they secured the cluster. Subsequently, PAM became the default authentication method. This release resolved permission issues encountered when inserting or overwriting a table. The introduction of many optimization techniques based on cost has made hive query processing cost-effective for big data applications. Now, the handling of join queries is wise, ensuring that they no longer produce incorrect data.

7. Version 1.2.1

The release of this version of Hive took place in the middle of 2015, alongside the launch of Hive ODBC drivers. The hive shells no longer gave an error after the start, a major change over this version. Hive meta store started making tables correctly, and no other exceptions ( such as lock exception) came while running a query. The development team released a stable version of the Hive and resolved major bugs in it.

Conclusion

Here from the above article, we saw how the Hive originated and the various versions introduced in the Hive, making it much more stable and powerful for big data processing. All the changes introduced in the hive versions were as par with the challenges we started facing for big data processing. They resolved these substantially, making the Hive more powerful for data processing.

Recommended Articles

We hope that this EDUCBA information on “Hive Versions” was beneficial to you. You can view EDUCBA’s recommended articles for more information,

  1. Bucketing in Hive | Features and Examples
  2. Newly Introduced Spark Versions
  3. What are the Apache Hadoop Versions?
  4. Hive Inner Join | Versions | Working and Examples
ADVERTISEMENT
SPSS Course Bundle - 14 Courses in 1 | 5 Mock Tests
34+ Hours of HD Videos
14 Courses
5 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
ADVERTISEMENT
MICROSOFT AZURE Course Bundle - 15 Courses in 1 | 12 Mock Tests
63+ Hour of HD Videos
15 Courses
12 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
ADVERTISEMENT
HADOOP Course Bundle - 32 Courses in 1 | 4 Mock Tests
125+ Hour of HD Videos
32 Courses
4 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
ADVERTISEMENT
INFORMATICA Course Bundle - 7 Courses in 1
47+ Hours of HD Videos
7 Courses
Verifiable Certificate of Completion
Lifetime Access
4.5
Primary Sidebar
Footer
Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
  • Blog as Guest
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

🚀 Cyber Monday Reloaded Price Drop! All in One Universal Bundle (3700+ Courses) @ 🎁 90% OFF - Ends in ENROLL NOW