You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Dongjoon Hyun (Jira)" <ji...@apache.org> on 2020/03/16 22:55:04 UTC
[jira] [Updated] (SPARK-25039) Binary comparison behavior should
refer to Teradata
[ https://issues.apache.org/jira/browse/SPARK-25039?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dongjoon Hyun updated SPARK-25039:
----------------------------------
Affects Version/s: (was: 3.0.0)
3.1.0
> Binary comparison behavior should refer to Teradata
> ---------------------------------------------------
>
> Key: SPARK-25039
> URL: https://issues.apache.org/jira/browse/SPARK-25039
> Project: Spark
> Issue Type: Improvement
> Components: SQL
> Affects Versions: 3.1.0
> Reporter: Yuming Wang
> Priority: Major
>
> The main difference is:
> # When comparing a {{StringType}} value with a {{NumericType}} value, Spark converts the {{StringType}} data to a {{NumericType}} value. But Teradata converts the {{StringType}} data to a {{DoubleType}} value.
> # When comparing a {{StringType}} value with a {{DateType}} value, Spark converts the {{DateType}} data to a {{StringType}} value. But Teradata converts the {{StringType}} data to a {{DateType}} value.
>
> More details:
> https://github.com/apache/spark/blob/65a4bc143ab5dc2ced589dc107bbafa8a7290931/sql/catalyst/src/main/scala/org/apache/spark/sql/catalyst/analysis/TypeCoercion.scala#L120-L149
> https://www.info.teradata.com/HTMLPubs/DB_TTU_16_00/index.html#page/SQL_Reference/B035-1145-160K/lrn1472241011038.html
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org