[
https://issues.apache.org/jira/browse/SPARK-29667?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16987440#comment-16987440
]
Hyukjin Kwon commented on SPARK-29667:
--------------------------------------
I think this issue is a duplicate of SPARK-29860. [The PR against
SPARK-29860|https://github.com/apache/spark/pull/26485] fixes this issue.
There are also related JIRAs and PRs such as
[SPARK-25056|https://github.com/apache/spark/pull/22038] and
[SPARK-22413|https://github.com/apache/spark/pull/19635].
Seems like we should better actively review than just leaving them
indefinitely. CC [~yumwang], [~mgaido], [~smilegator], [~cloud_fan].
> implicitly convert mismatched datatypes on right side of "IN" operator
> ----------------------------------------------------------------------
>
> Key: SPARK-29667
> URL: https://issues.apache.org/jira/browse/SPARK-29667
> Project: Spark
> Issue Type: Improvement
> Components: SQL
> Affects Versions: 2.4.3
> Reporter: Jessie Lin
> Priority: Minor
>
> Ran into error on this sql
> Mismatched columns:
> {code}
> [(a.`id`:decimal(28,0), db1.table1.`id`:decimal(18,0))]
> {code}
> the sql and clause
> {code}
> AND a.id in (select id from db1.table1 where col1 = 1 group by id)
> {code}
> Once I cast {{decimal(18,0)}} to {{decimal(28,0)}} explicitly above, the sql
> ran just fine. Can the sql engine cast implicitly in this case?
>
>
>
>
--
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
