[IMPALA-6230] The output type of a round() function should match the input type

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 2.10.0
• Fix Version/s: Impala 3.0
• Component/s: Backend, Frontend
• Labels: incompatibility
• Target Version: Impala 3.0
• Epic Color: ghx-label-2
• Assignee: Taras Bobrovytsky
• Reporter: Taras Bobrovytsky
• Created: 21/Nov/17 18:46
• Updated: 26/Mar/18 20:37
• Resolved: 26/Mar/18 20:37

Description

At the next compatibility breaking version we should revisit the output types of round() functions. In order to match the behavior of most of other database systems, the output type of the round() functions should be the same as the input type.

For example, today, round(double) returns a bigint. We should return a double instead.

Issue Links

• supercedes: IMPALA-3436 Round(double, int) should return decimal