[ https://issues.apache.org/jira/browse/SPARK-14197?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Hyukjin Kwon closed SPARK-14197. -------------------------------- Resolution: Cannot Reproduce I am closing this as Cannot Reproduce as I can't reproduce this against the current master. {code} scala> val df = spark.range(1).selectExpr("'12AA34' as imei", "'123' as MAC") df: org.apache.spark.sql.DataFrame = [imei: string, MAC: string] scala> df.createOrReplaceTempView("babu1") scala> spark.sql("select count(*) from babu1 where imei in ( select if (imei = '1AA10007',imei,NULL) from babu1)").show() +--------+ |count(1)| +--------+ | 0| +--------+ {code} > Error: org.apache.spark.sql.catalyst.analysis.UnresolvedException: Invalid > call to name on unresolved object, tree: unresolvedalias(if ((imei#33365 = > 1AA10007)) imei#33365 else cast(null as string)) (state=,code=0) > ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- > > Key: SPARK-14197 > URL: https://issues.apache.org/jira/browse/SPARK-14197 > Project: Spark > Issue Type: Bug > Components: SQL > Affects Versions: 1.5.1 > Reporter: Chetan Bhat > Priority: Minor > Original Estimate: 0.05h > Remaining Estimate: 0.05h > > In Beeline when the SQL is executed using Spark the following error occurs. > select count(*) from babu1 where imei in ( select if (imei = > '1AA10007',imei,NULL) from babu1); > Error: org.apache.spark.sql.catalyst.analysis.UnresolvedException: Invalid > call to name on unresolved object, tree: unresolvedalias(if ((imei#33365 = > 1AA10007)) imei#33365 else cast(null as string)) (state=,code=0) -- This message was sent by Atlassian JIRA (v6.3.4#6332) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org