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

   ### Describe the bug
   
   none of the scalar `array_` functions work on `FixedSizeList` dtype. 
   
   
   ### To Reproduce
   
   given a table of 
   
   ```
   +-----------------+--------+
   | fixed_size_list | list   |
   +-----------------+--------+
   | [0, 1]          | [0, 1] |
   | [0, 2]          | [0, 2] |
   +-----------------+--------+
   ```
   
   I should be able to use `array_*` functions on both `list` and 
`fixed_size_list` fields
   
   ```sql
   SELECT array_length(list) FROM my_table
   
   +-----------------------------+
   | array_length(my_table.list) |
   +-----------------------------+
   | 2                           |
   | 2                           |
   +-----------------------------+
   ```
   
   
   Full reproducible example here: 
https://gist.github.com/universalmind303/e2e59cd6d84656f5f20e78bd6e9c6c74
   
   ### Expected behavior
   
   ```sql
   SELECT array_length(fixed_size_list) FROM my_table
   
   +----------------------------------------+
   | array_length(my_table.fixed_size_list) |
   +----------------------------------------+
   | 2                                      |
   | 2                                      |
   +----------------------------------------+
   ```
   
   ### Additional context
   
   I don't think **all** of them should work. Such as ones that mutate the 
array (`repeat`, `remove`, ...). But I'd expect many of the immutable functions 
to work such as `has`, `length`, `element`, and so on. 


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

Reply via email to