You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@arrow.apache.org by "l1t1 (via GitHub)" <gi...@apache.org> on 2024/03/13 01:44:15 UTC

[I] add an alias to unnest() raise error [arrow-datafusion]

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

   ### Describe the bug
   
   ```sql
   ❯select unnest(generate_series(1,2));
   +--------------------------------------------+
   | unnest(generate_series(Int64(1),Int64(2))) |
   +--------------------------------------------+
   | 1                                          |
   | 2                                          |
   +--------------------------------------------+
   2 rows in set. Query took 0.002 seconds.
   
   ❯
   ❯select unnest(generate_series(1,2))a;
   type_coercion
   caused by
   Internal error: Unnest should be rewritten to LogicalPlan::Unnest before type coercion.
   This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
   ❯
   ❯select unnest(generate_series(1,2))as a;
   type_coercion
   caused by
   Internal error: Unnest should be rewritten to LogicalPlan::Unnest before type coercion.
   This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
   ```
   
   ### To Reproduce
   
   `select unnest(generate_series(1,2))a;`
   
   ### Expected behavior
   
   `select unnest(generate_series(1,2))a;` output same result as `select unnest(generate_series(1,2))` , and change the column name to a
   
   ### Additional context
   
   my version is on windows7
   DataFusion CLI v36.0.0


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


Re: [I] add an alias to unnest() raise error [arrow-datafusion]

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

    I am interested in implementing this enhancement.


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


Re: [I] add an alias to unnest() raise error [arrow-datafusion]

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

   I think it is not yet implemented feature, feel free to work on it if interested


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


Re: [I] add an alias to unnest() raise error [arrow-datafusion]

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

   take


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


Re: [I] add an alias to unnest() raise error [arrow-datafusion]

Posted by "jayzhan211 (via GitHub)" <gi...@apache.org>.
jayzhan211 closed issue #9589: add an alias to unnest() raise error
URL: https://github.com/apache/arrow-datafusion/issues/9589


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


Re: [I] add an alias to unnest() raise error [arrow-datafusion]

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

   @YjyJeff I think @jonahgao probably is working on it too.


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


Re: [I] add an alias to unnest() raise error [arrow-datafusion]

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

   I haven't really started yet, thank you @YjyJeff , I might review your PR later.


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


Re: [I] add an alias to unnest() raise error [arrow-datafusion]

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

   I implemented it in this [PR 9592](https://github.com/apache/arrow-datafusion/pull/9592) 😊


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