BubbaJoe commented on issue #6073: URL: https://github.com/apache/arrow-datafusion/issues/6073#issuecomment-1519192010
@jiangzhx Basically some of the functions and operators here: https://www.postgresql.org/docs/9.2/functions-array.html The most important being: array_length(anyarray), unnest(anyarray), and checking if an item is in an array. Example: ([`select * from any(items) = 'item'`](https://www.postgresql.org/docs/current/functions-subquery.html#FUNCTIONS-SUBQUERY-ANY-SOME)) BTW this query seems to parse correctly in datafusion, i just get an Unsupported/implemented error. I would perfer this way instead of something like array_contains(anyarray, anyelement) This is the error i get: `"This feature is not implemented: Unsupported ast node in sqltorel: AnyOp(Identifier(Ident { value: \"items\", quote_style: None }))"` -- 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]
