You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by Bhathiya Jayasekara <to...@gmail.com> on 2013/04/23 06:34:07 UTC

Getting rows of last hour

Hi all,

I have fallowing table.

*Name(String) | Capacity(String) | Time(BIGINT)*
*
*
I want to get rows which have 'Time' in last hour. How can I do that?

I tried following but didn't work.

*select * from table1 where Time > (unix_timestamp() - 60*60*1000);*
*
*
*
*
Thanks.

-Bhathiya.