apache / apache/datafusion

InList does not yet support nested columns.

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

Description

I ran the following SQL.
```sql
SELECT ALL m0.f0, m0.f1 FROM m0 WHERE (((CAST(m0.f0 AS STRING))LIKE(CAST('-1815689901' AS STRING)))) NOT IN (((CAST(m0.f1 AS STRING))LIKE(CAST(0.9733431918403004 AS STRING))));
```
But it doesn't support.

Oct 08 11:30:22.444 ERROR datafusion::scheduler: worker 10 panicked with: not implemented: InList does not yet support nested columns.
at datafusion-11.0.0/src/scheduler/mod.rs:107

Contributor guide

Open the contributing guide

Research direction

Reproduce the supplied SQL query against DataFusion 11.0.0 and inspect datafusion-11.0.0/src/scheduler/mod.rs:107, where the panic is reported. Trace the InList handling for nested columns and add coverage for this query. Done means the query executes without the "not implemented" panic and the behavior is covered by a test.

Written by the indexing model from the issue text.

Assessment

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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.