How to calculate no of hours between two dates in hive
<p>Write a hive query on to print all the phone numbers whose call duration is more than 60 min based on start and end time. One sample record is as below like this i have so many records in file.</p>

<pre><code> Phonenumber|callednumber|start time         |endtime            |Flag 
 9686365100 |9490444451  |2016-09-21 14-20-20|2016-09-21 14-20-60|T
</code></pre>