gaboraron opened a new issue, #37363: URL: https://github.com/apache/superset/issues/37363
### Bug description Hello, **Description** The bug is that a map type field is displayed as NULL at the SQL Lab query execution. This occurs when one of the map values contain some special characters (like '['). **Steps to reproduce:** 1. have a table with a map type column 2. populate the column for a record (A) with a map having one of the values the following sting "abc[d]" 3. populate the column for a record (B) with a map having one of the values the following sting "abcd" 4. execute a select like this: 'select map_attribute from my_table' The response will properly display "abcd" for record B but it will display NULL for record A. **Workaround:** Using 'select cast(map_attribute as json) as converted_attribute from my_table', both records will look as expected. **Expectation:** The result should look as expected without the workaround. ### Screenshots/recordings _No response_ ### Superset version 5.0.0 ### Python version Not applicable ### Node version Not applicable ### Browser Chrome ### Additional context - **Superset version: 4.1.2** - **Connection type: Athena** ### 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. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
