I think that Impala and Hive have this feature. Impala is faster than hive, hive is probably better to use in batch mode.
Alonso Isidoro Roman [image: https://]about.me/alonso.isidoro.roman <https://about.me/alonso.isidoro.roman?promo=email_sig&utm_source=email_sig&utm_medium=email_sig&utm_campaign=external_links> 2016-05-11 9:57 GMT+02:00 Divya Gehlot <divya.htco...@gmail.com>: > Hi, > I am using Spark 1.5.2 with Apache Phoenix 4.4 > As Spark 1.5.2 doesn't support subquery in where conditions . > https://issues.apache.org/jira/browse/SPARK-4226 > > Is there any alternative way to find foreign key constraints. > Would really appreciate the help. > > > > Thanks, > Divya >