You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@arrow.apache.org by "izveigor (via GitHub)" <gi...@apache.org> on 2023/07/15 19:05:34 UTC
[GitHub] [arrow-datafusion] izveigor opened a new issue, #6977: Implement `array_has` function
izveigor opened a new issue, #6977:
URL: https://github.com/apache/arrow-datafusion/issues/6977
### Is your feature request related to a problem or challenge?
## Summary
| Characteristic | Description |
| --------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Function name: | `array_has` |
| Aliases: | `list_has`, `array_contains`, `list_contains` |
| Original function?: | No |
| Function Description: | <b>Azure DataBricks:</b> Returns true if array contains value. </br> <b>Clickhouse:</b> Checks whether the ‘arr’ array has the ‘elem’ element. Returns 0 if the element is not in the array, or 1 if it is. </br> <b>DuckDB:</b> Returns true if the list contains the element. <b> </b> |
| Sources: | [Concept](https://github.com/apache/arrow-datafusion/discussions/6855) [Azure](https://learn.microsoft.com/en-us/azure/databricks/sql/language-manual/functions/array_contains) [ClickHouse](https://clickhouse.com/docs/en/sql-reference/functions/array-functions#hasarr-elem) [DuckDB](https://duckdb.org/docs/sql/functions/nested) |
## Examples:
```
select array_has([1, 2, 3, 4], 3);
----
true
```
```
select array_has([1, 2, 3, 4], 5);
----
false
```
### Describe the solution you'd like
_No response_
### Describe alternatives you've considered
_No response_
### Additional context
_No response_
--
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.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [arrow-datafusion] alamb closed issue #6977: Implement `array_has` function
Posted by "alamb (via GitHub)" <gi...@apache.org>.
alamb closed issue #6977: Implement `array_has` function
URL: https://github.com/apache/arrow-datafusion/issues/6977
--
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
[GitHub] [arrow-datafusion] izveigor commented on issue #6977: Implement `array_has` function
Posted by "izveigor (via GitHub)" <gi...@apache.org>.
izveigor commented on issue #6977:
URL: https://github.com/apache/arrow-datafusion/issues/6977#issuecomment-1637046042
> The original function is `No` in the description, but I think `array_has` is the same as the current function `array_contains` right?
Yes, the current implementation `array_contains` is equal to the future `array_has_all` (only we should rename it and include support column).
--
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
[GitHub] [arrow-datafusion] jayzhan211 commented on issue #6977: Implement `array_has` function
Posted by "jayzhan211 (via GitHub)" <gi...@apache.org>.
jayzhan211 commented on issue #6977:
URL: https://github.com/apache/arrow-datafusion/issues/6977#issuecomment-1637017468
The original function is `No` in the description, but I think `array_has` is the same as the current function `array_contains` right?
--
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