[jira] [Created] (SPARK-17592) SQL: CAST string as INT inconsistent with Hive

["Furcy Pin (JIRA)" <ji...@apache.org>]

Furcy Pin created SPARK-17592:
---------------------------------

             Summary: SQL: CAST string as INT inconsistent with Hive
                 Key: SPARK-17592
                 URL: https://issues.apache.org/jira/browse/SPARK-17592
             Project: Spark
          Issue Type: Bug
    Affects Versions: 2.0.0
            Reporter: Furcy Pin


Hello,
there seem to be an inconsistency between Spark and Hive when casting a string into an Int. 

With Hive:
{code}
select cast("0.4" as INT) ;
> 0
select cast("0.5" as INT) ;
> 0
select cast("0.6" as INT) ;
> 0
{code}

With Spark-SQL:
{code}
select cast("0.4" as INT) ;
> 0
select cast("0.5" as INT) ;
> 1
select cast("0.6" as INT) ;
> 1
{code}

Hive seems to perform a floor(string.toDouble), while Spark seems to perform a round(string.toDouble)

I'm not sure there is any ISO standard for this, mysql has the same behavior than Hive, while postgresql performs a string.toInt and throws an NumberFormatException

Personnally I think Hive is right, hence my posting this here.




--
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