Skip to content

Instantly share code, notes, and snippets.

@kleong

kleong/query_json_4.sql

Last active July 30, 2019 20:20
Show Gist options
  • Save kleong/b1eb6d67660b7f1608aeb607698331c8 to your computer and use it in GitHub Desktop.
Save kleong/b1eb6d67660b7f1608aeb607698331c8 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
query_json_4.sql
rockset> select mof.*
from new_collection, unnest(new_collection."my-other-field") as mof;
+------------+-------+------+---------+
| c1 | c2 | c3 | c4 |
|------------+-------+------+---------|
| unexpected | 99 | 100 | 101 |
| this | field | has | changed |
+------------+-------+------+---------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment