apache / apache/hudi

Enhance CREATE INDEX syntax for functional index

Open
#16,291 2 comments 0 reactions 1 assignee Assigned to @nsivabalan View on GitHub
from-jira priority:medium type:devtask
Dominant language
Java
Stars
6.2k
Forks
2.5k
Avg merge
2d 8h
Merged PRs (30d)
111

Description

Currently, user can create index using sql as follows: 

`create index idx_datestr on $tableName using column_stats(ts) options(expr='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'))`

## JIRA info

- Link: https://issues.apache.org/jira/browse/HUDI-7029
- Type: Task
- Epic: https://issues.apache.org/jira/browse/HUDI-512
- Fix version(s):
- 1.1.0

---

## Comments

24/Jul/24 07:13;codope;Need to enahnce sql grammar;;;

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.