[jira] [Commented] (HAWQ-304) Support update and delete on non-heap tables

2017-03-22 Thread Christian Tzolov (JIRA)

[ 
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

2017-03-16 Thread Hongxu Ma (JIRA)

[ 
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

2017-03-15 Thread Christian Tzolov (JIRA)

[ 
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

2016-12-27 Thread Kai Guo (JIRA)

[ 
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

2016-05-17 Thread Lei Chang (JIRA)

[ 
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

2016-05-17 Thread Michael Andre Pearce (IG) (JIRA)

[ 
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

2016-03-08 Thread Lei Chang (JIRA)

[ 
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

2016-03-03 Thread arron (JIRA)

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