You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@arrow.apache.org by "ZhangHuiGui (via GitHub)" <gi...@apache.org> on 2024/03/18 07:32:00 UTC
[I] [C++] Is there a better way to support 'Any'/'All' syntax with function expression [arrow]
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: issues-unsubscribe@arrow.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [C++] Is there a better way to support 'Any'/'All' syntax with function expression [arrow]
Posted by "thisisnic (via GitHub)" <gi...@apache.org>.
thisisnic commented on issue #40622:
URL: https://github.com/apache/arrow/issues/40622#issuecomment-3921306106
This issue has been closed because there has been no activity for the 14 days since the stale warning. Feel free to reopen if this has been closed in error.
--
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: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [C++] Is there a better way to support 'Any'/'All' syntax with function expression [arrow]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #40622:
URL: https://github.com/apache/arrow/issues/40622#issuecomment-3547076890
This issue has been marked as stale because it has had no activity in the past 365 days. Please remove the stale label or comment below, or this issue will be closed in 14 days. If this improvement is still desired but has no current owner, please add the 'Status: needs champion' label.
--
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: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [C++] Is there a better way to support 'Any'/'All' syntax with function expression [arrow]
Posted by "thisisnic (via GitHub)" <gi...@apache.org>.
thisisnic closed issue #40622: [C++] Is there a better way to support 'Any'/'All' syntax with function expression
URL: https://github.com/apache/arrow/issues/40622
--
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: issues-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org