Exercise 1.2: Basic CQL Fundamentals
ℹ️ For technical support, please contact us via email.
Load the CSV dataset into the table and execute queries
✅ Load the newly created table with the videos.csv file using the COPY command:
COPY videos FROM 'assets/videos.csv' WITH HEADER=true;
✅ Use SELECT to verify the data loaded correctly. Include LIMIT to retrieve only the first 10 rows.
SELECT * FROM videos LIMIT 10;
✅ Use SELECT to COUNT(*) the number of imported rows. It should match the number of rows COPY reported as imported.
SELECT COUNT(*) FROM videos;
✅ Use SELECT to find a row where the video_id = 6c4cffb9-0dc4-1d59-af24-c960b5fc3652.
SELECT * FROM videos WHERE video_id = 6c4cffb9-0dc4-1d59-af24-c960b5fc3652;