[ https://issues.apache.org/jira/browse/SPARK-14196?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Hyukjin Kwon closed SPARK-14196. -------------------------------- Resolution: Cannot Reproduce I am closing this as Cannot Reproduce as I can't 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("testolap") scala> spark.sql("select count(*) from testolap where imei in ( select case when imei like '%007%' then imei end from testolap)").show() +--------+ |count(1)| +--------+ | 0| +--------+ {code} > Error: org.apache.spark.sql.AnalysisException: cannot resolve > 'query_alias_fix_conflicts_0._c0'; (state=,code=0) > ---------------------------------------------------------------------------------------------------------------- > > Key: SPARK-14196 > URL: https://issues.apache.org/jira/browse/SPARK-14196 > 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 is > displayed. > select count(*) from testolap where imei in ( select case when imei like > '%007%' then imei end from testolap); > Error: org.apache.spark.sql.AnalysisException: cannot resolve > 'query_alias_fix_conflicts_0._c0'; (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