apache / apache/superset

SQL lab returns NULL values when there is data with complex maps.

Open
#42,840 3 comments 0 reactions 0 assignees View on GitHub
data:connect:athena sqllab validation:required
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.