hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Raihan Jamal <jamalrai...@gmail.com>
Subject Date Comparisons. in Hive
Date Thu, 04 Oct 2012 00:20:04 GMT
I have this below query from which I am trying to find out those records
that fall between midnight and 2 A.M on 18th September.
And *SojTimestampToDate *function will give me date in this format *yyyy/MM/dd
HH:mm:ss*
*
*
I am not sure whether the date comparison I did is right or not. And it
will give me all those records between midnight and 2 AM.

*SELECT event.app_payload ['n'] AS changed_cguid*
* FROM soj_session_container a LATERAL VIEW explode(a.events) t AS event*
* WHERE a.dt = '20120918'*
* AND SojTimestampToDate(event.event_timestamp) >= '2012/09/18 00:00:00'*
* AND SojTimestampToDate(event.event_timestamp) <= '2012/09/18 02:00:00'*

Can anyone shed some light on this whether I am doing right or not?



*Raihan Jamal*

Mime
View raw message