apache / apache/datafusion

Registering a record batch with the name json_table causes ParserError

Open
#9,122 7 comments 0 reactions 0 assignees View on GitHub
bug waiting-on-upstream
Dominant language
Rust
Stars
9.3k
Forks
2.4k
Avg merge
3d 7h
Merged PRs (30d)
344

Description

### Describe the bug

Registering a record batch under the name `json_table` leads to a ParserError.

### To Reproduce

You can find this repo https://github.com/dadepo/df-repro with code that can be used to reproduce the problem.

Running with the record batch registered with `json_table` will fail while the one registered with `json_values_table` runs successfully.

### Expected behavior

I believe it should be possible to use json_table as an alias for a record batch.

### Additional context

The issue is probably connected with this PR to add mysql's JSON_TABLE to sqlparser https://github.com/sqlparser-rs/sqlparser-rs/issues/1019

Contributor guide

Open the contributing guide

Research direction

Start with the reproduction repository at https://github.com/dadepo/df-repro and compare the failing record batch alias json_table with the working json_values_table alias. Inspect DataFusion's SQL parser integration in light of sqlparser-rs issue #1019; done means registering and querying a batch named json_table no longer raises ParserError.

Written by the indexing model from the issue text.

Assessment

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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.