title: Where clause with dates in hive
body: <p>The where clause in the below hive query is not working</p>
  
  <pre><code> select
   e.num as badge
  from dbo.events as e
   where  TO_DATE(e.event_time_utc) &gt; TO_DATE(select event_date from DL_EDGE_LRF_facilities.card_swipes_lastpulldate)
  </code></pre>
  
  <p>both event_time_utc and event_date fields are defined as strings and event_time_utc has timestamp values like '2017-09-18 20:10:19.000000' and event_date has only one date value like '2018-01-25' 
   i am getting an error like "cannot recognize input near '<code>select</code>' '<code>event_date</code>' 'from' in function specification " when i run the query, Please help</p>