Technically very do-able timestamps and other decimal types have been added over the years. It actually turns out to be a fair amount of work mostly due to the proliferations of serde that need to be able to read/write that type
On Sat, Nov 19, 2016 at 4:11 PM, Juan Delard de Rigoulières < j...@datarepublic.io> wrote: > Hi, > We'd like to extend Hive to support a new primitive type. For simplicity > sake, think of UUID. (https://en.wikipedia.org/wiki > /Universally_unique_identifier) > UUIDs are string with a particular/simple structure - known regex > matchable. (/^[0-9a-f]{8}-[0-9a-f]{4}-[1-5][0-9a-f]{3}-[89ab][0-9a-f]{ > 3}-[0-9a-f]{12}$/i) > We've looked into serde & udf but it doesn't seem elegant enough, so that > it's possible to write DDLs like: > *CREATE TABLE `awesome` {* > * users STRING,* > * id UUID* > *};* > We are looking to validation of values on ingestion (INSERT); so in the > example, values for the second column will get validated as UUID records. > Thanks in advance. > > Juan > >