Re: [I] Wrong error thrown when unnesting a list of struct [datafusion]

[via GitHub]

alamb closed issue #10656: Wrong error thrown when unnesting a list of struct
URL: https://github.com/apache/datafusion/issues/10656


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

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

[I] Wrong error thrown when unnesting a list of struct [datafusion]

[via GitHub]

duongcongtoai opened a new issue, #10656:
URL: https://github.com/apache/datafusion/issues/10656

   ### Describe the bug
   
   Given this slt
   ```
   statement ok
   CREATE TABLE temp
   AS VALUES
   ([struct(1,2)])
   ;
   
   query ?
   select unnest(column1) as struct_elem from temp;
   
   {c0: 1, c1: 2}
   ```
   The code will throw error 
   ```
   Internal error: unnest on struct can ony be applied at the root level of 
select expression 
   ```
   
   
   ### To Reproduce
   
   perform unnest on List(Struct) column, but with unnest as a child expr (e.g 
an alias)
   
   ### Expected behavior
   
   The type beling unnested is with type List, and unnesting(List(Struct)) 
should result into Struct correctly
   
   ### 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

Re: [I] Wrong error thrown when unnesting a list of struct [datafusion]

[via GitHub]

duongcongtoai commented on issue #10656:
URL: https://github.com/apache/datafusion/issues/10656#issuecomment-2130247278

   I'm open a PR to fix soon


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

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