Registering a record batch with the name json_table causes ParserError
- 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
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