You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@arrow.apache.org by "BubbaJoe (via GitHub)" <gi...@apache.org> on 2023/04/20 14:10:57 UTC

[GitHub] [arrow-datafusion] BubbaJoe opened a new issue, #6075: Add array expressiona

BubbaJoe opened a new issue, #6075:
URL: https://github.com/apache/arrow-datafusion/issues/6075

   ### Is your feature request related to a problem or challenge?
   
   Hello,
   
   I have an array data type and i would like to be able to run the following functions.
   
   ### Describe the solution you'd like
   
   array_length(col)
   array_contains(col<T>, T) `AND/OR` select * from my_table where 'text'=ANY(my_col);
   array_unnest()
   
   ```
   # TABLE
   | food | ingredients          |
   | ---- | -------------------- |
   | user | [eggs, salt, pepper] |
   
   # SQL INPUT
   # SELECT food, unnest(ingredients) from TABLE
   
   # SQL OUTPUT
   | food | unnest(ingredients) |
   | ---- | ------------------- |
   | user | eggs                |
   | user | pepper              |
   | user | salt                |
   ```
   
   ### 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 #6075: Add array expressions

Posted by "alamb (via GitHub)" <gi...@apache.org>.
alamb closed issue #6075: Add array expressions
URL: https://github.com/apache/arrow-datafusion/issues/6075


-- 
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] BubbaJoe commented on issue #6075: Add array expressions

Posted by "BubbaJoe (via GitHub)" <gi...@apache.org>.
BubbaJoe commented on issue #6075:
URL: https://github.com/apache/arrow-datafusion/issues/6075#issuecomment-1522497678

   @izveigor can you also add AnyOp design for check if an item is in an array? 
   
   Example: 'select * from my_table where 'text'=ANY(my_col);'


-- 
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 #6075: Add array expressions

Posted by "izveigor (via GitHub)" <gi...@apache.org>.
izveigor commented on issue #6075:
URL: https://github.com/apache/arrow-datafusion/issues/6075#issuecomment-1522260191

   Hello, @BubbaJoe!
   I have created the separate issue dedicated the implementation of the missing functions and operations for working with arrays: #6119


-- 
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