[VL] Spark allow compare Array type when contains null element in max/min-like agg, but Velox doesn't
Open
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
Assessment
This issue has not been assessed yet.