substrait icon indicating copy to clipboard operation
substrait copied to clipboard

Reuse connection to Extract,Consume and execute substrait query plans

Open pdet opened this issue 5 months ago • 0 comments

Up until now, we have been creating new connections to interact with substrait. This was necessary to circumvent the client context lock.

However, this was a brittle solution and especially problematic when dealing with temporary objects since these are not passed around new connections.

This PR allows us to reuse the same connection by utilizing a new flexible relation binder that allows us to consume and execute substrait plans from within the same connection; it also changes the from_substrait functions to use bind replace.

Aditionally, extracting plans will also go through a specialized code path, to allow us to use the same connection.

Since substrait also uses special options (e.g., some optimizations are disabled), these are set and reset on the original connection.

pdet avatar Sep 24 '24 11:09 pdet