drill icon indicating copy to clipboard operation
drill copied to clipboard

Support RDBMS update, INSERT,delete

Open weijunlu opened this issue 2 years ago • 4 comments

How to support RDBMS UPDATE, DELETE, and INSERT SQL statements with JdbcStoragePlugin

weijunlu avatar May 24 '22 16:05 weijunlu

@cgivre Does your company have such a demand?

luocooong avatar May 25 '22 11:05 luocooong

Yes actually. We've discussed working on this and looked into it a bit. Our priority would be INSERT statements. The good news is that Calcite already supports it, so the framework is already there. We'd just have to write a handler so that Drill knows what to do with the query plan.

cgivre avatar May 25 '22 11:05 cgivre

Yes actually. We've discussed working on this and looked into it a bit. Our priority would be INSERT statements. The good news is that Calcite already supports it, so the framework is already there. We'd just have to write a handler so that Drill knows what to do with the query plan.

I actually started a branch with some experimentation for this. Take a look if you'd like: https://github.com/cgivre/drill/tree/add_insert

cgivre avatar May 26 '22 01:05 cgivre

@cgivre Ok, thank you very much!

weijunlu avatar May 27 '22 07:05 weijunlu

Any updates on CUD functionalities on RDBMS? @cgivre

wschung1113 avatar Apr 12 '23 05:04 wschung1113