Hi Saurabh, Hive does not have a native date/time data type. In all the cases that we have seen, storing timestamp as BIGINT or STRING is good enough for our users' applications.
There is a set of UDFs for date/time stored as bigint/string: http://wiki.apache.org/hadoop/Hive/LanguageManual/UDF#head-8c92c62e9912ded44cc753d56fdf973ca1377f37 It's also very easy to write your own UDFs. Zheng On Mon, Jul 13, 2009 at 1:32 AM, Saurabh Nanda<[email protected]> wrote: > Hi, > > I'm a complete Hive newbie, so please excuse me if this question sounds too > dumb. I didn't see a native date/time data type at > http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL. Is this an omission > in the documentation or does Hive really not have a native date/time data > type? > > Should I convert the timestamp in my log files to a Unix timestamp (BIGINT) > and store it? Or should I treat the timestamp as a STRING? > > Thanks, > Saurabh. > -- > http://nandz.blogspot.com > http://foodieforlife.blogspot.com > -- Yours, Zheng
