apache / apache/gravitino

[Improvement] Support load indexes on multiple columns

Open
#2,535 1 comment 0 reactions 0 assignees View on GitHub
improvement
Dominant language
Java
Stars
3.2k
Forks
935
Avg merge
1d 15h
Merged PRs (30d)
315

Description

### What would you like to be improved?

1. create the following table in mysql
```
CREATE TABLE test (
id INT NOT NULL,
last_name CHAR(30) NOT NULL,
first_name CHAR(30) NOT NULL,
PRIMARY KEY (id),
INDEX name (last_name,first_name)
);
```
2.load the table in gravitino
there's only PRIMARY KEY indexes

It's better to support load another indexes

### How should we improve?

_No response_

Contributor guide

Open the contributing guide

Research direction

Start by reproducing the MySQL table definition and loading it into Gravitino, then trace the existing path that loads only PRIMARY KEY indexes. Check how a composite index on last_name and first_name is represented after loading, and verify that the non-primary index is preserved with both columns and its name.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, mysql
Domain
backend, databases
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.