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

Posted to commits@hudi.apache.org by "Sagar Sumit (Jira)" <ji...@apache.org> on 2023/11/27 17:18:00 UTC

[jira] [Assigned] (HUDI-7029) Enhance CREATE INDEX syntax for functional index

     [ https://issues.apache.org/jira/browse/HUDI-7029?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Sagar Sumit reassigned HUDI-7029:
---------------------------------

    Assignee: Sagar Sumit

> Enhance CREATE INDEX syntax for functional index
> ------------------------------------------------
>
>                 Key: HUDI-7029
>                 URL: https://issues.apache.org/jira/browse/HUDI-7029
>             Project: Apache Hudi
>          Issue Type: Task
>            Reporter: Sagar Sumit
>            Assignee: Sagar Sumit
>            Priority: Major
>             Fix For: 1.0.0
>
>
> Currently, user can create index using sql as follows: 
> `create index idx_datestr on $tableName using column_stats(ts) options(func='from_unixtime', format='yyyy-MM-dd')`
> Ideally, we would to simplify this further as follows:
> `create index idx_datestr on $tableName using column_stats(from_unixtime(ts, format='yyyy-MM-dd'))`



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