[SPARK-10866] [Spark SQL] [UDF] the floor function got wrong return value type

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.5.0
• Fix Version/s: 1.6.0
• Component/s: SQL
• Assignee: Cheng Hao
• Reporter: Yi Zhou
• Created: 29/Sep/15 03:17
• Updated: 22/Jun/19 07:01
• Resolved: 01/Oct/15 18:48

Description

As per floor definition,it should get BIGINT return value
-floor(DOUBLE a)
-Returns the maximum BIGINT value that is equal to or less than a.

But in current Spark implementation, it got wrong value type.
e.g.,
select floor(2642.12) from udf_test_web_sales limit 1;
2642.0

In hive implementation, it got return value type like below:
hive> select ceil(2642.12) from udf_test_web_sales limit 1;
OK
2642

Issue Links

• is duplicated by: SPARK-10724 SQL's floor() returns DOUBLE
• relates to: SPARK-28135 ceil/ceiling/floor/power returns incorrect values
• links to: [Github] Pull Request #8933 (chenghao-intel)