[
https://issues.apache.org/jira/browse/SPARK-22469?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16385156#comment-16385156
]
Xiaoju Wu commented on SPARK-22469:
-----------------------------------
[~liutang123] cast Decimal to Double is possible to lose precision, why did you
say "There is no proper decimal type we can pick, using double type is the best
we can do." ?
> Accuracy problem in comparison with string and numeric
> -------------------------------------------------------
>
> Key: SPARK-22469
> URL: https://issues.apache.org/jira/browse/SPARK-22469
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 2.2.0
> Reporter: Lijia Liu
> Assignee: Lijia Liu
> Priority: Major
> Fix For: 2.2.1, 2.3.0
>
>
> {code:sql}
> select '1.5' > 0.5; // Result is NULL in Spark but is true in Hive.
> {code}
> IIUC, we can cast string as double like Hive.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
