Support Questions
Find answers, ask questions, and share your expertise
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Is hive date/timestamp showtime ready?

Is hive date/timestamp showtime ready?

Super Guru

I am debating between using a column as string or date/timestamp. The field is a timestamp. however I see many jiras opened on hive date/timestamp which makes me believe I must ask the community prior to pushing forward. Of course all needs to be tested. However I want the communities feedback whether to avoid or not.


Re: Is hive date/timestamp showtime ready?

Rising Star

There are many issues with timestamps, you're right, especially for older versions of Hive. Anyway, I'd suggest you to try to use timestamps. If you'll face any issue, you can ask the community or decide to revert to string...

Re: Is hive date/timestamp showtime ready?

Expert Contributor

I have used time stamp as a string as well as date as well as timestamp, Advantages of using date and time is you could use date and time functions like unixtimestamp(), year() etc.. within hive this is much efficient than using string, especially if you have to do any sum bys or group bys.

Re: Is hive date/timestamp showtime ready?


I have been using date and timestamp for some time and haven't run into any issues. In fact, for a customer we recommended moving away from string to timestamp for getting better compression.

If you can list all the JIRAs in your question, we can look at each one to see if you will run into issues on latest hive.

Don't have an account?
Coming from Hortonworks? Activate your account here