[
https://issues.apache.org/jira/browse/HAWQ-304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15929455#comment-15929455
]
Hongxu Ma edited comment on HAWQ-304 at 3/22/17 3:00 AM:
---------------------------------------------------------
Great job @[~tzolov]
I have tried your calcite-sql-rewriter, but failed on HAWQ:
https://github.com/tzolov/calcite-sql-rewriter/issues/1
Not support HAWQ now?
Update: already support HAWQ, thanks Christian
demo:
{code}
$ java -jar ./target/journalled-sql-rewriter-example-1.7-SNAPSHOT.jar
src/main/resources/myTestModel.json
[main] INFO io.pivotal.calcite.sqlrewriter.Main - INSERT INTO hr.depts (deptno,
department_name) VALUES(696, 'Pivotal')
[main] INFO io.pivotal.calcite.sqlrewriter.Main - updated rows: 1
[main] INFO io.pivotal.calcite.sqlrewriter.Main - SELECT * FROM hr.depts
[main] INFO io.pivotal.calcite.sqlrewriter.Main - result: 696 , Pivotal ,
[main] INFO io.pivotal.calcite.sqlrewriter.Main - UPDATE hr.depts SET
department_name='interma' WHERE deptno = 696
[main] INFO io.pivotal.calcite.sqlrewriter.Main - updated rows: 1
[main] INFO io.pivotal.calcite.sqlrewriter.Main - SELECT * FROM hr.depts
[main] INFO io.pivotal.calcite.sqlrewriter.Main - result: 696 , interma ,
[main] INFO io.pivotal.calcite.sqlrewriter.Main - DELETE FROM hr.depts WHERE
deptno = 696
[main] INFO io.pivotal.calcite.sqlrewriter.Main - updated rows: 1
[main] INFO io.pivotal.calcite.sqlrewriter.Main - SELECT * FROM hr.depts
[main] INFO io.pivotal.calcite.sqlrewriter.Main - result:
[main] INFO io.pivotal.calcite.sqlrewriter.Main - Done
{code}
was (Author: hongxu ma):
Great job @[~tzolov]
I have tried your calcite-sql-rewriter, but failed on HAWQ:
https://github.com/tzolov/calcite-sql-rewriter/issues/1
Not support 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)
