[jira] [Created] (SPARK-20744) IN with multiple columns does not work

["Bogdan Raducanu (JIRA)" <ji...@apache.org>]

Bogdan Raducanu created SPARK-20744:
---------------------------------------

             Summary: IN with multiple columns does not work
                 Key: SPARK-20744
                 URL: https://issues.apache.org/jira/browse/SPARK-20744
             Project: Spark
          Issue Type: Bug
          Components: SQL
    Affects Versions: 2.3.0
            Reporter: Bogdan Raducanu


The following code reproduces the problem:

{code}
scala> spark.range(10).selectExpr("id as a", "id as b").where("(a,b) in ((1,1))").show
org.apache.spark.sql.AnalysisException: cannot resolve '(named_struct('a', `a`, 'b', `b`) IN (named_struct('col1', 1, 'col2', 1)))' due to data type mismatch: Arguments must be same type; line 1 pos 6;
'Filter named_struct(a, a#42L, b, b#43L) IN (named_struct(col1, 1, col2, 1))
+- Project [id#39L AS a#42L, id#39L AS b#43L]
   +- Range (0, 10, step=1, splits=Some(1))
{code}



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org