[ 
https://issues.apache.org/jira/browse/SPARK-10744?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Hyukjin Kwon closed SPARK-10744.
--------------------------------
    Resolution: Cannot Reproduce

I can't reproduce this in the current master.

{code}
scala> val df = Seq((1, 1)).toDF("c1", "cnnull")
df: org.apache.spark.sql.DataFrame = [c1: int, cnnull: int]

scala> df.registerTempTable("t1")
warning: there was one deprecation warning; re-run with -deprecation for details

scala> spark.sql("select c1 from t1 where 1 * cnnull is null").show()
+---+
| c1|
+---+
+---+


scala> spark.sql("select c1 from t1 where (1 * cnnull) is null").show()
+---+
| c1|
+---+
+---+
{code}

> parser error (constant * column is null interpreted as constant * boolean)
> --------------------------------------------------------------------------
>
>                 Key: SPARK-10744
>                 URL: https://issues.apache.org/jira/browse/SPARK-10744
>             Project: Spark
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 1.5.0
>            Reporter: N Campbell
>            Priority: Minor
>
> SPARK SQL inherits the same defect as Hive where this statement will not 
> parse/execute. See HIVE-9530 
>  select c1 from t1 where 1 * cnnull is null 
> -vs- 
>  select c1 from t1 where (1 * cnnull) is null 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to