Kimahriman opened a new issue, #898: URL: https://github.com/apache/datafusion-comet/issues/898
### What is the problem the feature request solves? Support for extracting elements from an array. Spark has two expressions for doing this: `GerArrayItem` and `ElementAt`. These have a lot in common, with only minor differences for zero or one based, negative indices, and a default value, so they can probably be combined into a single DataFusion expression. ### Describe the potential solution Currently DataFusion has an `ArrayElement` expression which acts like `ElementAt`, but without the fail on error ANSI support and default value support, which is only needed for the `SplitPart` Spark expression via runtime replacement. It makes more sense to implement a custom function to support these behaviors, as well as also handle the `GetArrayItem` functionality that is zero based and doesn't support negative indices. ### 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-unsubscr...@datafusion.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org For additional commands, e-mail: github-h...@datafusion.apache.org