[CH] The ut of the GLUTEN-3534 is randomly failed in the `GlutenClickHouseTPCHParquetSuite`
- 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:

But it runs successfully in the `GlutenClickHouseTPCHParquetAQESuite`.
### Spark version
None
### Spark configurations
_No response_
### System information
_No response_
### Relevant logs
_No response_
Contributor guide
Assessment
This issue has not been assessed yet.