You are viewing a plain text version of this content. The canonical link for it is here.

Posted to github@arrow.apache.org by GitBox <gi...@apache.org> on 2022/05/02 16:05:14 UTC

[GitHub] [arrow-datafusion] andygrove opened a new issue, #2417: Allow subqueries without aliases

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

   **Is your feature request related to a problem or challenge? Please describe what you are trying to do.**
   DataFusion currently does not allow subqueries without aliases so does not support queries like the following, which Spark supports.
   
   I checked the ANSI SQL:2016 specification and I could not see anything in there that requires subqueries to have aliases either, although I think that Postgres may require it.
   
   ``` 
   scala> spark.sql("SELECT * FROM (SELECT * FROM t1)").show
   +---+
   | c0|
   +---+
   |  1|
   |  2|
   |  3|
   +---+
   ```
   
   **Describe the solution you'd like**
   I would like this query to work in DataFusion.
   
   **Describe alternatives you've considered**
   None
   
   **Additional context**
   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: github-unsubscribe@arrow.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [arrow-datafusion] andygrove closed issue #2417: Allow subqueries without aliases

Posted by GitBox <gi...@apache.org>.

andygrove closed issue #2417: Allow subqueries without aliases
URL: https://github.com/apache/arrow-datafusion/issues/2417


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