Help Center/ MapReduce Service/ FAQs/ MRS Overview/ What Are the Differences Between Hive Versions?
Updated on 2022-09-14 GMT+08:00
View PDF

What Are the Differences Between Hive Versions?

Hive 3.1 has the following differences when compared with Hive 1.2:

  • String cannot be converted to int.
  • The user-defined functions (UDFs) of the Date type are changed to Hive built-in UDFs.
  • Hive 3.1 does not provide the index function anymore.
  • Hive 3.1 uses the UTC time in time functions, while Hive 1.2 uses the local time zone.
  • The JDBC drivers in Hive 3.1 and Hive 1.2 are incompatible.
  • In Hive 3.1, column names in ORC files are case-sensitive and underscores-sensitive.
  • Hive 3.1 does not allow columns named time.
Parent topic: MRS Overview