SQL lab returns NULL values when there is data with complex maps.
- Dominant language
- Python
- Stars
- 74.8k
- Forks
- 18.3k
- Avg merge
- 2d 5h
- Merged PRs (30d)
- 685
Description
### Bug description
When using SQLLab for querying map returns NULL in case of special characters.
Example query:
```
SELECT *
FROM (
VALUES (
MAP(
ARRAY['key'],
ARRAY['{"key2":[string]}']
)
)
) AS t(payload);
```
When running this through Athena the result is {key={"key2":[string]}}
However in SQLLab it returns NULL
Similar issue was recently closed:
https://github.com/apache/superset/issues/37363
This is still an issue in Superset 6.1.0
### Screenshots/recordings
_No response_
### Superset version
6.1.0
### Python version
3.12
### Node version
I don't know
### Browser
Not applicable
### Additional context
_No response_
### Checklist
- [x] I have searched Superset docs and Slack and didn't find a solution to my problem.
- [x] I have searched the GitHub issue tracker and didn't find a similar bug report.
- [x] I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section.
Contributor guide
Research direction
Start in SQLLab by running the provided Athena query and comparing its result with the expected map value. Review the related issue #37363 for context, then trace where complex map results are handled; done means the query displays {key={"key2":[string]}} instead of NULL in Superset 6.1.0.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- python, sql
- Domain
- backend, data
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Quiet
- Clarity
- Mostly clear
- Newbie friendliness
- 48/100