apache / apache/gluten

[CH] `select timestamp_micros(-9223372036854775808)` in spark throws overflow exception, while `select fromUnixTimestamp64Micro(-9223372036854775808)` doesn't

Open
#7,127 0 comments 0 reactions 0 assignees View on GitHub
bug triage
Dominant language
Scala
Stars
1.6k
Forks
657
Avg merge
2d 21h
Merged PRs (30d)
85

Description

### Backend

CH (ClickHouse)

### Bug description

s

### Spark version

Spark-3.3.x

### Spark configurations

_No response_

### System information

_No response_

### Relevant logs

_No response_

Contributor guide

Open the contributing guide

Research direction

Start by reproducing the two SQL expressions in the ClickHouse backend with Spark 3.3.x, using the minimum 64-bit timestamp value shown in the title. Compare the overflow behavior of timestamp_micros and fromUnixTimestamp64Micro; done means the expressions behave consistently without the reported exception.

Written by the indexing model from the issue text.

Assessment

Tech stack
clickhouse
Domain
backend, databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
20/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.