Allows conversion execution of Substrait query plans
Compatibility Matrix
This table covers all DuckDB releases that have not reached end-of-life, including LTS releases, and shows the 2 most recent patch releases of each. Older patch releases are not listed, but the extension may be available for them as well.
| Platform | 1.4.4 | 1.4.5 | 1.5.5 | 1.5.6 | 2.0.0 |
|---|---|---|---|---|---|
| Linux AMD64 | |||||
| Linux ARM64 | |||||
| macOS AMD64 | |||||
| macOS ARM64 | |||||
| Windows AMD64 | |||||
| Windows ARM64 | |||||
| WebAssembly |
Installing and Loading
INSTALL substrait FROM community;
LOAD substrait;
Example
.mode line
CALL get_substrait('SELECT count(exercise) AS exercise FROM crossfit WHERE difficulty_level <= 5');
Added Functions
| function_name | function_type | description | comment | examples |
|---|---|---|---|---|
| get_substrait | table | Converts the provided query into a binary Substrait plan | NULL | NULL |
| get_substrait_json | table | Converts the provided query into a Substrait plan in JSON | NULL | NULL |
| from_substrait | table | Executes a binary Substrait plan (provided as bytes) against DuckDB and returns the results | NULL | NULL |
| from_substrait_json | table | Executes a Substrait plan written in JSON against DuckDB and returns the results | NULL | NULL |
Overloaded Functions
This extension does not add any function overloads.
Added Types
This extension does not add any types.
Added Settings
This extension does not add any settings.