apache / apache/paimon

[Bug] flink db sync action will failed and exit when the mysql table has `TIME` data type

Open
#1,764 2 comments 0 reactions 0 assignees View on GitHub
bug
Dominant language
Java
Stars
3.4k
Forks
1.4k
Avg merge
1d 11h
Merged PRs (30d)
396

Description

### Search before asking

- [X] I searched in the [issues](https://github.com/apache/incubator-paimon/issues) and found nothing similar.

### Paimon version

master

### Compute Engine

flink

### Minimal reproduce step

1. start a flink database sync action to sync mysql db to paimon
2. the mysql table has `TIME` data type.
3. create hive table error, throw an exception ` Unsupported type: TIME(0)` , failed and exit.

### What doesn't meet your expectations?

failed and exit.

### Anything else?

_No response_

### Are you willing to submit a PR?

- [X] I'm willing to submit a PR!

Contributor guide

No contributing guide indexed for this repository

Research direction

Start with the Flink database sync action and its MySQL-to-Paimon type handling; reproduce the failure using a MySQL table with a TIME column and the reported Unsupported type: TIME(0) error. Done means the sync no longer fails and exits for this schema, with the relevant verification added or updated.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, mysql
Domain
data-engineering, databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 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.