You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Apache Spark (JIRA)" <ji...@apache.org> on 2018/02/05 10:59:00 UTC
[jira] [Commented] (SPARK-23335) expression 'select
conv('ffffffffffffffff',16,10) % 2' return 0
[ https://issues.apache.org/jira/browse/SPARK-23335?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16352239#comment-16352239 ]
Apache Spark commented on SPARK-23335:
--------------------------------------
User 'caneGuy' has created a pull request for this issue:
https://github.com/apache/spark/pull/20508
> expression 'select conv('ffffffffffffffff',16,10) % 2' return 0
> ---------------------------------------------------------------
>
> Key: SPARK-23335
> URL: https://issues.apache.org/jira/browse/SPARK-23335
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 2.1.0
> Reporter: zhoukang
> Priority: Major
>
> For below expression:
> {code:java}
> select conv('ffffffffffffffff',16,10) % 2;
> {code}
> it will return 0.
> {code:java}
> 0: jdbc:hive2://c3-hadoop-prc-history03.bj:16> select conv('ffffffffffffffff',16,10) % 2;
> +----------------------------------------------------------------------------------------------+--+
> | (CAST(conv(ffffffffffffffff, 16, 10) AS DOUBLE) % CAST(CAST(2 AS DECIMAL(20,0)) AS DOUBLE)) |
> +----------------------------------------------------------------------------------------------+--+ | 0.0 | +----------------------------------------------------------------------------------------------+--+
> {code}
> It caused by:
> {code:java}
> case a @ BinaryArithmetic(left @ StringType(), right) => a.makeCopy(Array(Cast(left, DoubleType), right)) case a @ BinaryArithmetic(left, right @ StringType()) => a.makeCopy(Array(left, Cast(right, DoubleType)))
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org