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

["Yi Zhou (JIRA)" <ji...@apache.org>]

Yi Zhou created SPARK-10866:
-------------------------------

             Summary: [Spark SQL] [UDF] the floor function got wrong return value type
                 Key: SPARK-10866
                 URL: https://issues.apache.org/jira/browse/SPARK-10866
             Project: Spark
          Issue Type: Bug
          Components: SQL
    Affects Versions: 1.5.0
            Reporter: Yi Zhou




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




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org