[HIVE-15511] Provide an option in months_between UDF to disable rounding-off

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 2.2.0
• Labels: TODOC2.2
• Hadoop Flags: Reviewed
• Assignee: Rajesh Balamohan
• Reporter: Rajesh Balamohan
• Created: 26/Dec/16 04:54
• Updated: 26/Jul/17 00:03
• Resolved: 27/Dec/16 05:24

Description

Rounding off was added in GenericUDFMonthsBetween so that it can be compatible with systems like oracle. However, there are places where rounding off is not needed.

E.g "CAST(MONTHS_BETWEEN(l_shipdate, l_commitdate) / 12 AS INT)" may not need rounding off via BigDecimal which is compute intensive.