[
https://issues.apache.org/jira/browse/HAWQ-304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15936618#comment-15936618
]
Christian Tzolov commented on HAWQ-304:
---------------------------------------
Glad to hear it works [~hongxu ma]!
We are still working on correctness vs. efficiency implementation of the INSERT
rule. We may end-up implementing two different InsertRule strategies and allow
the user to configure the prefered one:
https://github.com/tzolov/calcite-sql-rewriter/issues/2
Another observation. It seems like HAWQ doesn't support OVER-PARTITION-BY
without an explicit ORDER BY! Furthermore it seems that HAWQ allays performs
internal Sort
My interpretation of Postgres spec:
https://www.postgresql.org/docs/current/static/sql-expressions.html#SYNTAX-WINDOW-FUNCTIONS
is that a missing `frame_clause` is equal to `ROWS BETWEEN UNBOUNDED PRECEDING
AND UNBOUNDED FOLLOWING`. In both cases you shouldn't need ORDER BY.
I assume that unnecessary SORT would incur undesired performance overhead.
> Support update and delete on non-heap tables
> --------------------------------------------
>
> Key: HAWQ-304
> URL: https://issues.apache.org/jira/browse/HAWQ-304
> Project: Apache HAWQ
> Issue Type: Wish
> Components: Storage
> Reporter: Lei Chang
> Assignee: Lili Ma
> Fix For: 3.0.0.0
>
> Attachments: mutable_table.sql
>
>
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
