[
https://issues.apache.org/jira/browse/PHOENIX-154?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15176431#comment-15176431
]
Maryann Xue commented on PHOENIX-154:
-------------------------------------
What would be useful here is to make the sliding window an independent module
so that it can ported on PARTITION BY easily, both for client-side use and for
server-side use.
To achieve this, you may start with ORDER BY when table is unordered to figure
out the basics for implementing sliding windows (since it will be purely
client-side), then after that you can move onto ORDER BY when table is ordered
and see if your original sliding window module can pushed to the server side
and see how you'd deal with region boundary rows. This might not give you
significant performance improvement in the ORDER BY case alone (without
PARTITION BY), but it would definitely be very helpful for the PARTITION BY
case (when ordered).
> Support SQL OLAP extensions
> ---------------------------
>
> Key: PHOENIX-154
> URL: https://issues.apache.org/jira/browse/PHOENIX-154
> Project: Phoenix
> Issue Type: New Feature
> Reporter: James Taylor
> Labels: gsoc2016
>
> Support the WINDOW, PARTITION OVER, GROUPING, RANK, DENSE RANK, ORDER BY etc.
> functionality.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
