You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@phoenix.apache.org by "James Taylor (JIRA)" <ji...@apache.org> on 2016/03/01 08:24:18 UTC

[jira] [Commented] (PHOENIX-154) Support SQL OLAP extensions

    [ https://issues.apache.org/jira/browse/PHOENIX-154?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15173374#comment-15173374 ] 

James Taylor commented on PHOENIX-154:
--------------------------------------

For (1), you need to confirm whether or not Apache Calcite supports the syntax you're proposing as that's a prerequisite. If they don't, then you need to work with the syntax they have.

I'm not sure I follow (2). Assuming the rows are ordered by the partition key, why wouldn't sliding windows help? Probably best to comment directly on PHOENIX-2700 and write the query you think will express what we want to do (and we can further discuss there).

For (3), no, it'd need to work across the multiple region servers (that's kind of the point). You can do work on the client as well (that's how we support aggregation).

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