[ https://issues.apache.org/jira/browse/SPARK-35632?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Takeshi Yamamuro resolved SPARK-35632. -------------------------------------- Resolution: Not A Problem > SELECT rand(cast(3 / 7 AS int)) value gives different resultset in Spark 3.1 > as compared to Spark 2.4.5 > ------------------------------------------------------------------------------------------------------- > > Key: SPARK-35632 > URL: https://issues.apache.org/jira/browse/SPARK-35632 > Project: Spark > Issue Type: Bug > Components: SQL > Affects Versions: 3.1.1 > Environment: Spark 3.1.1 > Reporter: Chetan Bhat > Priority: Minor > > Issue - SELECT rand(cast(3 / 7 AS int)) value gives different resultset in > Spark 3.1 as compared to Spark 2.4.5 > Queries are executed in Spark beeline. > > Output in Spark 3.1 > 0: jdbc:hive2://10.20.253.239:23040/default> SELECT rand(cast(3 / 7 AS int)); > +----------------------------------------------------+ > | rand(CAST((CAST(3 AS DOUBLE) / CAST(7 AS DOUBLE)) AS INT)) | > +----------------------------------------------------+ > | 0.7604953758285915 | > +----------------------------------------------------+ > 1 row selected (0.042 seconds) > Output in Spark 2.4.5 > 0: jdbc:hive2://linux-63:22550/> SELECT rand(cast(3 / 7 AS int)); > +-------------------------------------------------------------+ > | rand(CAST((CAST(3 AS DOUBLE) / CAST(7 AS DOUBLE)) AS INT)) | > +-------------------------------------------------------------+ > | 0.8446490682263027 | > +-------------------------------------------------------------+ > 1 row selected (6.358 seconds) -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org