[jira] [Created] (SPARK-14197) 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)

["Chetan Bhat (JIRA)" <ji...@apache.org>]

Chetan Bhat created SPARK-14197:
-----------------------------------

             Summary: 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
            Reporter: Chetan Bhat
            Priority: Minor
             Fix For: 1.5.1


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-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org