describe_twitter.sql

rockset> DESCRIBE twitter_collection;
+-----------------------------------------------+---------------+---------+-----------+
| field                                         | occurrences   | total   | type      |
|-----------------------------------------------+---------------+---------+-----------|
| ['id']                                        | 4181419       | 4181419 | string    |
| ['_event_time']                               | 4181419       | 4181419 | timestamp |
| ['coordinates']                               | 4178582       | 4181419 | null_type |
| ['coordinates']                               | 2837          | 4181419 | object    |
| ['coordinates', 'type']                       | 2837          | 2837    | string    |
| ['coordinates', 'coordinates']                | 2837          | 2837    | array     |
| ['coordinates', 'coordinates', '*']           | 5673          | 5674    | float     |
| ['coordinates', 'coordinates', '*']           | 1             | 5674    | int       |
| ['created_at']                                | 4181419       | 4181419 | string    |
| ['display_text_range']                        | 228832        | 4181419 | array     |
| ['display_text_range', '*']                   | 457664        | 457664  | int       |
| ['entities']                                  | 4181419       | 4181419 | object    |
| ['entities', 'hashtags']                      | 4181419       | 4181419 | array     |
| ['entities', 'hashtags', '*']                 | 1301581       | 1301581 | object    |
| ['entities', 'hashtags', '*', 'indices']      | 1301581       | 1301581 | array     |
| ['entities', 'hashtags', '*', 'indices', '*'] | 2603162       | 2603162 | int       |
| ['entities', 'hashtags', '*', 'text']         | 1301581       | 1301581 | string    |
| ['entities', 'user_mentions']                 | 4181419       | 4181419 | array     |
+-----------------------------------------------+---------------+---------+-----------+