Re: [I] Planning error for compound expressions involving window functions [datafusion]

2025-04-05 Thread via GitHub
jonahgao closed issue #14910: Planning error for compound expressions involving window functions URL: https://github.com/apache/datafusion/issues/14910 -- 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 t

Re: [I] Planning error for compound expressions involving window functions [datafusion]

2025-03-05 Thread via GitHub
alamb commented on issue #14910: URL: https://github.com/apache/datafusion/issues/14910#issuecomment-2702165477 See @chenkovsky's PR here: - https://github.com/apache/datafusion/pull/15033 -- This is an automated message from the Apache Git Service. To respond to the message, please log

Re: [I] Planning error for compound expressions involving window functions [datafusion]

2025-03-01 Thread via GitHub
2010YOUY01 commented on issue #14910: URL: https://github.com/apache/datafusion/issues/14910#issuecomment-2692543687 > I dont think I can fix this lol, I tried tweaking `rebase_expr` and `check_columns_satisfy_exprs` in `datafusion/sql/src/utils.rs` but all failed. The planner is little too

Re: [I] Planning error for compound expressions involving window functions [datafusion]

2025-03-01 Thread via GitHub
qazxcdswe123 commented on issue #14910: URL: https://github.com/apache/datafusion/issues/14910#issuecomment-2692166597 untake -- 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.

Re: [I] Planning error for compound expressions involving window functions [datafusion]

2025-03-01 Thread via GitHub
qazxcdswe123 commented on issue #14910: URL: https://github.com/apache/datafusion/issues/14910#issuecomment-2692166110 I dont think I can fix this lol, I tried tweaking `rebase_expr` and `check_columns_satisfy_exprs` in `datafusion/sql/src/utils.rs` but all failed. The planner is little too

Re: [I] Planning error for compound expressions involving window functions [datafusion]

2025-02-28 Thread via GitHub
qazxcdswe123 commented on issue #14910: URL: https://github.com/apache/datafusion/issues/14910#issuecomment-2690157890 After some digging I found that this only occur when using `WINDOW` clause. So this one works ``` SELECT t1.v1, SUM(t1.v1) OVER (ORDER BY t1.v1 ROW

Re: [I] Planning error for compound expressions involving window functions [datafusion]

2025-02-28 Thread via GitHub
qazxcdswe123 commented on issue #14910: URL: https://github.com/apache/datafusion/issues/14910#issuecomment-2690159920 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.

[I] Planning error for compound expressions involving window functions [datafusion]

2025-02-27 Thread via GitHub
2010YOUY01 opened a new issue, #14910: URL: https://github.com/apache/datafusion/issues/14910 ### Describe the bug The following query throws planning error for `DataFusion`, but it runs in `DuckDB` and `PostgreSQL` Run in datafusion-cli (commit hash a28f2834c) ```sh Data