apache / apache/paimon

[Feature] Paimon lance format should support timestamp_ltz

Open
#6,648 0 comments 0 reactions 0 assignees View on GitHub
enhancement
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/paimon/issues) and found nothing similar.

### Motivation

Currently, Paimon lance format doesn't support timestamp_ltz, when set timezone to `GMT-10:00`, it will throw `Unsupported timestamp type: timestamp:us:GMT-10:00`.

### Solution

The exception is thrown in https://github.com/lance-format/lance/blob/main/rust/lance-core/src/datatypes.rs#L357.
The core reason is arrow-rust can't recognize `GMT-10:00`, it can only recognize IANA timezone like `America/New_York` or UTC offset format like `+07:30`. So users follow the two ways to set timezone, no exception will happen.

### Anything else?

_No response_

### Are you willing to submit a PR?

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

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by tracing Paimon's lance-format handling for timestamp_ltz and compare the accepted timezone forms with lance-core/src/datatypes.rs. Reproduce the GMT-10:00 failure, then verify that timestamp_ltz works with that timezone while IANA names and UTC offsets remain supported.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, rust
Domain
data-engineering
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
42/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.