[VL][1.5] Result mismatch of `from_unixtime` function
Open
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
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