[jira] [Commented] (HAWQ-304) Support update and delete on non-heap tables
[ https://issues.apache.org/jira/browse/HAWQ-304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=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)
[jira] [Commented] (HAWQ-304) Support update and delete on non-heap tables
[ https://issues.apache.org/jira/browse/HAWQ-304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15929455#comment-15929455 ] Hongxu Ma commented on HAWQ-304: Great job [~tzolov] I have tried your calcite-sql-rewriter, but failed on HAWQ: https://github.com/tzolov/calcite-sql-rewriter/issues/1 not supported HAWQ now? > 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)
[jira] [Commented] (HAWQ-304) Support update and delete on non-heap tables
[ https://issues.apache.org/jira/browse/HAWQ-304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15926286#comment-15926286 ] Christian Tzolov commented on HAWQ-304: --- FYI, we have been working on this workaround: https://github.com/tzolov/calcite-sql-rewriter It leverages Apache Calcite to implement JDBC driver that converts the INSERT, UPDATE and DELETE statements into append-only INSERTs. E.g. instead of updating rows in-place it inserts the new version of the row along with version metadata. > 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)
[jira] [Commented] (HAWQ-304) Support update and delete on non-heap tables
[ https://issues.apache.org/jira/browse/HAWQ-304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15780021#comment-15780021 ] Kai Guo commented on HAWQ-304: -- I think the precondition of supporting update and delete is index support in [HAWQ-303]. > 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.4#6332)
[jira] [Commented] (HAWQ-304) Support update and delete on non-heap tables
[ https://issues.apache.org/jira/browse/HAWQ-304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15288018#comment-15288018 ] Lei Chang commented on HAWQ-304: it is possible and the item is currently under investigation. and after investigation, the design will be proposed... > 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: New Feature > Components: Storage >Reporter: Lei Chang > Fix For: 3.0.0 > > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HAWQ-304) Support update and delete on non-heap tables
[ https://issues.apache.org/jira/browse/HAWQ-304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15287610#comment-15287610 ] Michael Andre Pearce (IG) commented on HAWQ-304: Is there any schedule around this e.g. q3 2016, q4 2016? Just as this is also for us a very critical sql feature needed, that some other products can already support as can now even Hive. As such if q3/q4 then one can argue to business to keep with Hawq as defacto sql on hadoop, but longer period this becomes a bit harder. > 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: New Feature > Components: Storage >Reporter: Lei Chang > Fix For: 3.0.0 > > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HAWQ-304) Support update and delete on non-heap tables
[ https://issues.apache.org/jira/browse/HAWQ-304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15184980#comment-15184980 ] Lei Chang commented on HAWQ-304: right. > 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: New Feature > Components: Storage >Reporter: Lei Chang > Fix For: 3.0.0 > > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HAWQ-304) Support update and delete on non-heap tables
[ https://issues.apache.org/jira/browse/HAWQ-304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15179320#comment-15179320 ] arron commented on HAWQ-304: it means that hawq wil support update or deleteoperation start with 3.0.0 verion, right? > 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: New Feature > Components: Storage >Reporter: Lei Chang > Fix For: 3.0.0 > > -- This message was sent by Atlassian JIRA (v6.3.4#6332)