apache / apache/gravitino

[Improvement] PostgreSQL serial column not supported

Open
#2,426 2 comments 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

### Version

main branch

### Describe what's wrong

If you try to view a PostgreSQL table with a serial type the Gravitino UI gives an error.

### Error message and/or stacktrace

UI give this error:
"Unknown data type for literal: JdbcTypeBean{typeName='serial', columnSize='10', scale='0'}"

### How to reproduce

Using the lastest playground, create a table and view in the UI.

```SQL
create table hr.new_departments (
department_id serial NOT NULL,
department_name varchar(100) NULL
);
```

### Additional context

_No response_

Contributor guide

Open the contributing guide

Research direction

Start by reproducing the issue in the latest playground using the provided CREATE TABLE statement, then trace the UI path that displays the PostgreSQL table and reports the unknown serial type. Done means a table with a serial column can be viewed in the UI without the reported data-type error; no specific source file or test is named in the issue.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, postgresql
Domain
databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.