apache / apache/gluten

[VL][1.5] Result mismatch of `from_unixtime` function

Open
#11,080 0 comments 0 reactions 0 assignees View on GitHub
bug triage
Dominant language
Scala
Stars
1.6k
Forks
657
Avg merge
2d 14h
Merged PRs (30d)
80

Description

### Backend

VL (Velox)

### Bug description

sql:

```
select from_unixtime(1549787517000, 'yyyy-MM-dd');
```

spark result: `+51080-10-23`

gluten result: `51080-10-23`

### Gluten version

Gluten-1.5

### Spark version

Spark-3.5.x

### Spark configurations

_No response_

### System information

_No response_

### Relevant logs

```bash

```

Contributor guide

Open the contributing guide

Research direction

Start by running the reported SQL query with Spark 3.5.x and Gluten 1.5 using the VL backend, then compare the formatted results. Trace the from_unixtime implementation and its result-formatting path; done means Gluten produces the same output as Spark, including the leading sign.

Written by the indexing model from the issue text.

Assessment

Tech stack
scala, spark, sql
Domain
backend, data
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.