Skip to content

Instantly share code, notes, and snippets.

@kleong

kleong/describe_user_mentions.sql

Created August 13, 2019 00:28
Show Gist options
  • Save kleong/9e952b5dfe031596814d6e3014ee0ef8 to your computer and use it in GitHub Desktop.
Save kleong/9e952b5dfe031596814d6e3014ee0ef8 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
describe_user_mentions.sql
rockset> DESCRIBE twitter_collection:entities.user_mentions;
+-----------------------+---------------+----------+-----------+
| field | occurrences | total | type |
|-----------------------+---------------+----------+-----------|
| ['*'] | 1531518 | 1531518 | object |
| ['*', 'id'] | 329 | 1531518 | null_type |
| ['*', 'id'] | 1531189 | 1531518 | int |
| ['*', 'id_str'] | 1531189 | 1531518 | string |
| ['*', 'id_str'] | 329 | 1531518 | null_type |
| ['*', 'indices'] | 1531518 | 1531518 | array |
| ['*', 'indices', '*'] | 3063036 | 3063036 | int |
| ['*', 'name'] | 1531189 | 1531518 | string |
| ['*', 'name'] | 329 | 1531518 | null_type |
| ['*', 'screen_name'] | 1531518 | 1531518 | string |
+-----------------------+---------------+----------+-----------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment