apache / apache/gluten

[VL] Spark allow compare Array type when contains null element in max/min-like agg, but Velox doesn't

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

Description

### Description

```
spark-sql> select * from test_arr;
[1,2] 1
[null,3] 2
spark-sql> select max(arr) from test_arr;
[1,2]
spark-sql> select min(arr) from test_arr;
[null,3]
```

```
presto:default> select * from test;
arr | id
-----------+----
[1, 2] | 1
[null, 3] | 2
(2 rows)

presto:default> select max(arr) from test;
Query 20240124_023546_00015_zxjem, FAILED, 1 node
Query 20240124_023546_00015_zxjem failed: ARRAY comparison not supported for arrays with null elements
```

https://github.com/facebookincubator/velox/issues/6314

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.