I suggest you store unix timestamp in hive, and so you can compare it
as BIGINT without worrying about STRING comparison.
And if your data is to be queried on daily bases, you can split one
big file into small files, say, one file per day, then add them as
partitions of soj_session_container. This
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 */MM/dd
HH:mm:ss*
*
*
I am not sure whether the date comparison I did is right or not. And it
will
