Change theme
Help
Press space for more information.
Show links for this issue (Shortcut: i, l)
Copy issue ID
Previous Issue (Shortcut: k)
Next Issue (Shortcut: j)
Sign in to use full features.
Vote: I am impacted
Notification menu
Refresh (Shortcut: Shift+r)
Go home (Shortcut: u)
Pending code changes (auto-populated)
View issue level access limits(Press Alt + Right arrow for more information)
Request for new functionality
View staffing
Description
- ~1M rows
- ~100 key value rows ({"5396": 150, "5397": 300, "5398": 450, "5399": 600, "5400": 750, "5401": 900}")
We are using using REGEX but it gets pretty easy to mess up. For example, the moment someone needs string values that can contain special symbols (e.g. ":" or ",") it's probably going to break in a way hard to fix via regular expressions. We are fearing that JavaScript UDF will eventually lead to performance problems like in
Is it possible to add JSON_EXTRACT_MAP that would return MAP<STRING, scalar_type> in a sense similar to JSON_EXTRACT_SCALAR? (scalar key + scalar value, where scalar_type ideally depends on JSON type; but would be fine if you always returned MAP<STRING, STRING> if it works for any JSON scalar type)
PS: similar to JSON_EXTRACT_ARRAY request: