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

["Sean Owen (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/SPARK-10866?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Sean Owen updated SPARK-10866:
------------------------------
    Assignee: Cheng Hao

> [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
>            Assignee: Cheng Hao
>             Fix For: 1.6.0
>
>
> 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