Skip to content

Instantly share code, notes, and snippets.

@kleong

kleong/query_json_5.sql

Last active July 30, 2019 20:20
Show Gist options
  • Save kleong/c3fcc5137e7891848832b5deeda0dbc7 to your computer and use it in GitHub Desktop.
Save kleong/c3fcc5137e7891848832b5deeda0dbc7 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
query_json_5.sql
rockset> select typeof(mof.c2)
from new_collection, unnest(new_collection."my-other-field") as mof;
+-----------+
| ?typeof |
|-----------|
| int |
| string |
+-----------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment