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