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/04/27 20:11:59 UTC

[GitHub] [arrow-datafusion] andygrove opened a new issue, #2361: Validate subquery expressions

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

   **Is your feature request related to a problem or challenge? Please describe what you are trying to do.**
   The SQL query planner and the DataFrame API both allow logical plans to be created that contain subquery expressions but we do not yet do any validation on these expressions.
   
   Examples of validation we should do:
   - Scalar subqueries should return a single row and single column
   - IN subqueries should return a single column
   
   **Describe the solution you'd like**
   I am leaning towards performing this validation in an optimizer rule because that would be applied regardless of how the logical plan was created.
   
   **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] jon-chuang commented on issue #2361: Validate subquery expressions

Posted by GitBox <gi...@apache.org>.
jon-chuang commented on issue #2361:
URL: https://github.com/apache/arrow-datafusion/issues/2361#issuecomment-1120147996

   @andygrove is there any reason why we can't support multiple columns in the IN subquery? As far as implementation goes, it's fairly trivial.


-- 
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] mingmwang commented on issue #2361: Validate subquery expressions

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

   @jon-chuang
   I think we do not support named Struct in DataFusion today.


-- 
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] mingmwang commented on issue #2361: Validate subquery expressions

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

   I am working on it now.


-- 
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] mingmwang commented on issue #2361: Validate subquery expressions

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

   This issue is resolved.


-- 
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] mingmwang closed issue #2361: Validate subquery expressions

Posted by "mingmwang (via GitHub)" <gi...@apache.org>.
mingmwang closed issue #2361: Validate subquery expressions
URL: https://github.com/apache/arrow-datafusion/issues/2361


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