Hive has native timestamp types, which work seamlessly with date and time functions. These functions remove the need for a lot of (CPU-intensive) manual casting and math, so it would be nice to use them in place of or in addition to the MediaWiki-style string timestamps.
That's a shame! Do you have a general sense of when we might upgrade to 1.2? 3 months? A year? Never?
Cloudera needs to provide a distro that includes this version of hive, I think that release is several months late as I remember @Ottomata saying it was scheduled for early 2017.
most current distro is on hive 1.1 : https://www.cloudera.com/documentation/enterprise/release-notes/topics/cm_vd_cdh_package_tarball_512.html#cm_vd_cdh_package_tarball_512
This is actually resolved! When I originally filed this, the timestamps were stored in Mediawiki's string format (e.g. 20180514215953), but in June 2017 we started storing in JDBC format (e.g. 2018-05-14 21:59:53.0). This means Hive's date and time functions can now operate on them.
Of course, this is now inconsistent with EventLogging timestamps in the Data Lake, which are stored in ISO 8601 format (e.g. 2018-05-14T21:59:53), but that's another issue 😁