You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Jerome Isaac Haltom (Jira)" <ji...@apache.org> on 2026/05/22 18:21:00 UTC

[jira] [Comment Edited] (CALCITE-5898) Add UUID function (enabled in Presto library)

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

Jerome Isaac Haltom edited comment on CALCITE-5898 at 5/22/26 6:20 PM:
-----------------------------------------------------------------------

Is there any preference as to what this function name should be in Calcite?

Lots of examples:

gen_random_uuid in PG. Apparently with uuidv4 and uuidv7 functions for specific variants.

NEWID and NEWSEQUENTIALID in MSSQL

SYS_GUID in Oracle.


was (Author: JIRAUSER287703):
Is there any preference as to what this function name should be in Calcite?

Lots of examples:

gen_random_uuid in PG. With _v1, _v4 and _v7 variants.

NEWID and NEWSEQUENTIALID in MSSQL

SYS_GUID in Oracle.

> Add UUID function (enabled in Presto library)
> ---------------------------------------------
>
>                 Key: CALCITE-5898
>                 URL: https://issues.apache.org/jira/browse/CALCITE-5898
>             Project: Calcite
>          Issue Type: Sub-task
>          Components: core
>    Affects Versions: 1.35.0
>            Reporter: Runkang He
>            Priority: Major
>
> Add UUID function (enabled in Presto library)
> UUID: Returns a pseudo randomly generated [UUID|https://prestodb.io/docs/current/language/types.html#uuid-type] (type 4).
> See more details in [Presto|https://prestodb.io/docs/current/functions/uuid.html] doc.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)