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

Reply via email to