Chetan Bhat created SPARK-14199: ----------------------------------- Summary: Error: org.apache.spark.sql.hive.huawei.rules.analyze.UnrelatedSubqueryConversion$MultiValueException$: subquery expression must return single column! (state=,code=0) Key: SPARK-14199 URL: https://issues.apache.org/jira/browse/SPARK-14199 Project: Spark Issue Type: Bug Components: SQL Affects Versions: 1.5.1 Reporter: Chetan Bhat Priority: Minor
In Beeline when the SQL is executed using Spark error is displayed. select imei,a, (select MAC from babu8 a where a.imei = '1AA10007' ) from ( select imei,count(contractNumber)+1 a from testolap group by imei) a where imei in ( select imei from testolap where imei like '%007%') group by imei, a; Error: org.apache.spark.sql.hive.huawei.rules.analyze.UnrelatedSubqueryConversion$MultiValueException$: subquery expression must return single column! (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