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-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org

Reply via email to