https://community.cloudera.com/t5/Support-Questions/How-to-ask-hive-query-to-fetch-data-for-specific-partition/m-p/115210#M78004 <PRE>floor(datediff(to_date(from_unixtime(unix_timestamp())), to_date(birthdate)) / 365.25</PRE><P>That unix_timestamp() could turn off a few optimizations in the planner, which might not be related to this issue.</P><P>Start using CURRENT_DATE instead of the unix_timestamp() call, for faster queries.</P> Thu, 02 Jun 2016 15:22:09 GMT gopalv 2016-06-02T15:22:09Z