You are viewing a plain text version of this content. The canonical link for it is here.
Posted to reviews@spark.apache.org by wangyum <gi...@git.apache.org> on 2018/10/18 09:17:29 UTC

[GitHub] spark issue #21871: [SPARK-24916][SQL] Fix type coercion for IN expression w...

Github user wangyum commented on the issue:

    https://github.com/apache/spark/pull/21871
  
    workaround:
    ```sql
    SELECT * FROM t4
    WHERE
    (t4a, t4b, t4c) IN (SELECT t5a, t5b, t5c FROM t5);
    
    ->
    
    SELECT * FROM t4
    WHERE
    (t4a, t4b, t4c) IN (SELECT CAST(t5a as DOUBLE), CAST(t5b AS STRING), CAST(t5c AS STRING) FROM t5);
    ```



---

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