Exercise 3.1: User Defined Types (UDTs)
ℹ️ For technical support, please contact us via email.
Explore the KillrVideo dataset
After reviewing your design of the tables that support tag and year queries, your manager happened to remember that there isn't a tags column in the original table that stores video metadata. You have now been asked to include that in the videos table schema and also to add another column to store video encoding information.
The revised videos table schema:
| Column Name | Data Type |
|---|---|
| video_id | timeuuid |
| added_date | timestamp |
| description | text |
| encoding | video_encoding |
| tags | set |
| title | text |
| user_id | uuid |
The encoding data structure:
| Column Name | Data Type |
|---|---|
| bit_rates | set |
| encoding | text |
| height | int |
| width | int |
✅ Review the contents of the CSV files with video metadata:
head -n 10 assets/videos.csv
head -n 10 assets/videos_encoding.csv