apache / apache/gluten

[CH] The ut of the GLUTEN-3534 is randomly failed in the `GlutenClickHouseTPCHParquetSuite`

Open
#3,731 0 comments 0 reactions 1 assignee Claimed by @baibaichen View on GitHub
bug triage
Dominant language
Scala
Stars
1.6k
Forks
657
Avg merge
2d 14h
Merged PRs (30d)
80

Description

### Backend

CH (ClickHouse)

### Bug description

The sql shown below will be randomly failed in the `GlutenClickHouseTPCHParquetSuite`:
```
select t1.l_orderkey, t2.o_orderkey, extract(year from t1.l_shipdate), t2.o_year,
t1.l_cnt, t2.o_cnt
from (
select l_orderkey, l_shipdate, count(1) as l_cnt
from lineitem
group by l_orderkey, l_shipdate) t1
join (
select o_orderkey, extract(year from o_orderdate) as o_year, count(1) as o_cnt
from orders
group by o_orderkey, o_orderdate) t2
on t1.l_orderkey = t2.o_orderkey
and extract(year from t1.l_shipdate) = o_year
order by t1.l_orderkey, t2.o_orderkey
limit 100
```

The results are not match with the vanilla spark:
![image](https://github.com/oap-project/gluten/assets/9430290/f26f63d3-ecee-46ca-a303-d049ca36a7ac)

But it runs successfully in the `GlutenClickHouseTPCHParquetAQESuite`.

### Spark version

None

### Spark configurations

_No response_

### System information

_No response_

### Relevant logs

_No response_

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.