title: Hive column as a subquery select
body: <p>I'm trying to do something like below with Hive.  How can I have a column in Hive be defined as a subquery?  Is this possible in Hive?</p>
  
  <pre><code>hive -e "           
  select
  distinct i.SearchListingID,
  (select count(*) 
      from calls c 
      where c.ServiceID = i.SearchListingID
      ) as CallsCount
  from Impressions i
  where i.yyyymmdd = 20120401
  limit 10" &gt; ImpressionCalls.txt
  
  Hive history file=/tmp/jd/hive_job_log_jd_201205222049_550931420.txt
  </code></pre>
  
  <blockquote>
    <p>FAILED: Parse Error: line 4:1 cannot recognize input near 'select' 'count' '(' in expression specification</p>
  </blockquote>