apache / apache/datafusion

[substrait] [sqllogictest] Unsupported plan type: RecursiveQuery

Open
#16,274 6 comments 0 reactions 0 assignees View on GitHub
bug
Dominant language
Rust
Stars
9.3k
Forks
2.4k
Avg merge
3d 7h
Merged PRs (30d)
344

Description

### Describe the bug

~10 sqllogictest cases are failing in Substrait round-trip mode because of the following error:
```
query failed: DataFusion error: This feature is not implemented: Unsupported plan type: RecursiveQuery
```

### To Reproduce

```
cargo test --test sqllogictests -- --substrait-round-trip cte.slt:175
```

### Expected behavior

The sqllogictest passes in Substrait round-trip mode

### Additional context

This is part of a broader initiative to improve the reliability of Substrait-to-DataFusion logical plan conversions.
- https://github.com/apache/datafusion/issues/16248

Contributor guide

Open the contributing guide

Research direction

Run `cargo test --test sqllogictests -- --substrait-round-trip cte.slt:175` to reproduce the failure. Trace the Substrait-to-DataFusion logical plan conversion for `RecursiveQuery` and use the failing sqllogictest case as the success criterion. Done means the affected sqllogictest cases pass in Substrait round-trip mode.

Written by the indexing model from the issue text.

Assessment

Tech stack
rust
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
38/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.