Re: nested select is not working in spark sql

2015-10-29 Thread Deenar Toraskar
e this helps, > Rick Hillegas > > > > Kishor Bachhav wrote on 10/28/2015 05:52:50 AM: > > > From: Kishor Bachhav > > To: user@spark.apache.org > > Date: 10/28/2015 05:53 AM > > Subject: nested select is not working in spark sql > > > &g

Re: nested select is not working in spark sql

2015-10-28 Thread Richard Hillegas
: Kishor Bachhav > To: user@spark.apache.org > Date: 10/28/2015 05:53 AM > Subject: nested select is not working in spark sql > > Hi, > I am trying to execute below query in spark sql but throws exception > > select n_name from NATION where n_regionkey = (select r_regionkey

nested select is not working in spark sql

2015-10-28 Thread Kishor Bachhav
Hi, I am trying to execute below query in spark sql but throws exception select n_name from NATION where n_regionkey = (select r_regionkey from REGION where r_name='ASIA') Exception: Exception in thread "main" java.lang.RuntimeException: [1.55] failure: ``)'' expected but identifier r_regionkey