title: how to write subquery and use "In" Clause in Hive
body: <p>How can I use In clause in Hive 
  I want to write something like this in Hive
    select x from y where y.z in (select distinct z from y) order by x;
  But I am not finding any way of doing it..
  I tried In clause in Hive 0.7 it was throwing error, Also I tried Find_in_Set ..
  using find_in_set(y.z,subquery).. but the job is getting failed.</p>
  
  <p>I want to do this on Hive. Please help me if anybody knows how to do this in Hive..</p>
  
  <p>Thanks &amp; Regards,
  Atul </p>