walterddr opened a new issue, #11627:
URL: https://github.com/apache/pinot/issues/11627
queries with the same partition but a missing or non-missing order-by clause:
```
SELECT
ROW_NUMBER() OVER (PARTITION BY a ORDER BY b) ,
COUNT(*) OVER (PARTITION BY a)
from tbl
```
should be allowed, b/c both are partitioned by a
can we:
```
LogicalWindow(window#0=[window(partition {3} aggs [SUM($13)])])
PinotLogicalExchange(distribution=[hash[3]]) <-- get rid of this
exchange?
LogicalWindow(window#0=[window(partition {3} order by [10] rows
between UNBOUNDED PRECEDING and CURRENT ROW aggs [ROW_NUMBER()])])
PinotLogicalSortExchange(distribution=[hash[3]],
collation=[[10]], isSortOnSender=[false], isSortOnReceiver=[true])
LogicalProject(D_DATE=[$3], D_DATEKEY=[$4],
D_DAYNUMINMONTH=[$5], D_DAYNUMINWEEK=[$6], D_DAYNUMINYEAR=[$7],
D_DAYOFWEEK=[$8], D_HOLIDAYFL=[$9], D_LASTDAYINMONTHFL=[$10],
D_LASTDAYINWEEKFL=[$11], D_MONTH=[$12], D_MONTHNUMINYEAR=[$13],
D_SELLINGSEASON=[$14], D_WEEKDAYFL=[$15], D_WEEKNUMINYEAR=[$16], D_YEAR=[$17],
D_YEARMONTH=[$18], D_YEARMONTHNUM=[$19])
LogicalFilter(condition=[OR(=($8, 'Monday'), =($8,
'Sunday'))])
LogicalTableScan(table=[[ssb_dates]])
```
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
