You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@arrow.apache.org by "comphead (via GitHub)" <gi...@apache.org> on 2023/05/03 15:44:46 UTC
[GitHub] [arrow-datafusion] comphead opened a new issue, #6207: Add user friendly message when invalid WINDOW frame
comphead opened a new issue, #6207:
URL: https://github.com/apache/arrow-datafusion/issues/6207
### Is your feature request related to a problem or challenge?
If the window frame is invalid the error message is wordy and not user friendly
```
❯ select row_number() over (rows between -1 preceding and current row) from (select 1 a);
Internal error: Window frame bound cannot be UnaryOp { op: Minus, expr: Value(Number("1", false)) }. 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
❯
```
### Describe the solution you'd like
Handle error messages properly. Good example
```
❯ select row_number() over (rows between 1 following and current row) from (select 1 a);
Error during planning: Invalid window frame: start bound (1 FOLLOWING) cannot be larger than end bound (CURRENT ROW)
```
### Describe alternatives you've considered
_No response_
### 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-unsubscribe@arrow.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [arrow-datafusion] comphead commented on issue #6207: Add user friendly message when invalid WINDOW frame
Posted by "comphead (via GitHub)" <gi...@apache.org>.
comphead commented on issue #6207:
URL: https://github.com/apache/arrow-datafusion/issues/6207#issuecomment-1533280153
Fixing those minors
--
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] alamb closed issue #6207: Add user friendly message when invalid WINDOW frame
Posted by "alamb (via GitHub)" <gi...@apache.org>.
alamb closed issue #6207: Add user friendly message when invalid WINDOW frame
URL: https://github.com/apache/arrow-datafusion/issues/6207
--
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