calcite-sql-rewriter
calcite-sql-rewriter copied to clipboard
tzolov
JDBC driver that converts any INSERT, UPDATE and DELETE statements into append-only INSERTs. Instead of updating rows in-place it inserts the new version of the row along with version metadata
build on centos7 and with psql(hawq): ``` ------------------------------------------------------- T E S T S ------------------------------------------------------- psql: invalid connection option "postgresql://localhost:5432/postgres?user" java.io.IOException: Broken pipe at java.io.FileOutputStream.writeBytes(Native Method) at java.io.FileOutputStream.write(FileOutputStream.java:326) at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82) at...
Existing [JournalledInsertRule](https://github.com/tzolov/calcite-sql-rewriter/blob/master/journalled-sql-rewriter/src/main/java/org/apache/calcite/adapter/jdbc/JournalledInsertRule.java) implementation is designed for high throughput and minimal overhead. Rule converts INSERT on `virtual table` into INSERT on the target `journal table`. In practice the performance of the...
