Skip to content

Instantly share code, notes, and snippets.

@kleong
Created August 21, 2019 19:08
Show Gist options
  • Save kleong/565fe7d1211f4bcfccd2856f44c969d3 to your computer and use it in GitHub Desktop.
Save kleong/565fe7d1211f4bcfccd2856f44c969d3 to your computer and use it in GitHub Desktop.
rockset> DESCRIBE movie_ratings
+--------------------------------------------+---------------+---------+-----------+
| field | occurrences | total | type |
|--------------------------------------------+---------------+---------+-----------|
| ['12 Strong'] | 1 | 3 | object |
| ['12 Strong', 'Genre'] | 1 | 1 | string |
| ['12 Strong', 'Gross'] | 1 | 1 | string |
| ['12 Strong', 'IMDB Metascore'] | 1 | 1 | string |
| ['12 Strong', 'Popcorn Score'] | 1 | 1 | int |
| ['12 Strong', 'Rating'] | 1 | 1 | string |
| ['12 Strong', 'Tomato Score'] | 1 | 1 | int |
| ['A Ciambra'] | 1 | 3 | object |
| ['A Ciambra', 'Genre'] | 1 | 1 | string |
| ['A Ciambra', 'Gross'] | 1 | 1 | string |
| ['A Ciambra', 'IMDB Metascore'] | 1 | 1 | string |
| ['A Ciambra', 'Popcorn Score'] | 1 | 1 | string |
| ['A Ciambra', 'Rating'] | 1 | 1 | string |
| ['A Ciambra', 'Tomato Score'] | 1 | 1 | string |
| ['The Final Year'] | 1 | 3 | object |
| ['The Final Year', 'popcornscore'] | 1 | 1 | int |
| ['The Final Year', 'rating'] | 1 | 1 | string |
| ['The Final Year', 'tomatoscore'] | 1 | 1 | int |
+--------------------------------------------+---------------+---------+-----------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment