hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jeremy Beard (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-12721) Add UUID built in function
Date Mon, 21 Dec 2015 19:22:46 GMT

    [ https://issues.apache.org/jira/browse/HIVE-12721?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15066927#comment-15066927
] 

Jeremy Beard commented on HIVE-12721:
-------------------------------------

I also looked into creating a second UUID function that would return a DECIMAL, but the range
of UUIDs (2^128) does not fit within the largest DECIMAL precision (10^38).

> Add UUID built in function
> --------------------------
>
>                 Key: HIVE-12721
>                 URL: https://issues.apache.org/jira/browse/HIVE-12721
>             Project: Hive
>          Issue Type: Improvement
>          Components: UDF
>            Reporter: Jeremy Beard
>            Assignee: Jeremy Beard
>         Attachments: HIVE-12721.patch
>
>
> A UUID function would be very useful for ETL jobs that need to generate surrogate keys.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message