ZhangHuiGui opened a new issue, #40622:
URL: https://github.com/apache/arrow/issues/40622
### Describe the enhancement requested
Query like below in PostgreSQL:
```sql
tpch1g=# explain select n_name from nation where n_nationkey > ANY
(array[9,2,8]);
QUERY PLAN
-----------------------------------------------------------
Seq Scan on nation (cost=0.00..12.34 rows=120 width=104)
Filter: (n_nationkey > ANY ('{9,2,8}'::integer[]))
```
Postgresql support ANY/ALL syntax with specific internal operation like
`less`,`equal`, `great`, `less_equal` ...
We want to use arrow's built-in compute function to implement this with high
performance. Seems there is no suitable function to support it.
- `IsIn`, can only support the `equal` situation by use a simple internal
Memotable.
- `Any` and `All` in api_aggregate can only support boolean array as input.
I know that it's a special syntax in PostgreSQL, but seems reasonable for us
to support this kind of function?
### Component(s)
C++
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
