[ https://issues.apache.org/jira/browse/SPARK-19754?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15889419#comment-15889419 ]
Takeshi Yamamuro commented on SPARK-19754: ------------------------------------------ cc: [~hyukjin.kwon] what do u think this? > Casting to int from a JSON-parsed float rounds instead of truncating > -------------------------------------------------------------------- > > Key: SPARK-19754 > URL: https://issues.apache.org/jira/browse/SPARK-19754 > Project: Spark > Issue Type: Bug > Components: SQL > Affects Versions: 1.6.3, 2.1.0 > Reporter: Juan Pumarino > Priority: Minor > > When retrieving a float value from a JSON document, and then casting it to an > integer, Hive simply truncates it, while Spark is rounding up when the > decimal value is >= 5. > In Hive, the following query returns {{1}}, whereas in a Spark shell the > result is {{2}}. > {code} > SELECT CAST(get_json_object('{"a": 1.6}', '$.a') AS INT) > {code} -- This message was sent by Atlassian JIRA (v6.3.15#6346) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org