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.