After Loading and Importing Data from the two files attached to an EC2 instance.
In a cassandra sample videodb schemas
this project needed the following query statements and its results into one document.
query1. List all the videos(represented by videoid) uploaded by the user with userid of 9761d3d7-7fbd-4269-9988-6cfd4e188678. Display the most recent upload first.
q2. Lookup all the comments made on video 99051fe9-6a9c-46c2-b949-38ef78858dd0. Display the comments, userids who made the comments, and time when comments were made.
q3. Lookup all the videos with "cassandra" tag. Output each video name and the time when "cassandra" tag was added to the video.
q4.
1)List the last three events of the video 99051fe9-6a9c-46c2-b949-38ef78858dd0. What is the response? Why?
2)List the three most recent events of the video 99051fe9-6a9c-46c2-b949-38ef78858dd0, which were incurred by the user with id of d0f60aa8-54a9-4840-b70c-fe562b68842b.
q5.
1)List all tags made on video named "Become a Super Modeler." What is the response? Why?
2)Find a strategy to answer the query in 1). Include in your answer the stategy, the complete solution and its result.
q6.
1)Remove "instruction" tag from the video 873ff430-9c23-4e60-be5f-278ea2bb21bd and add a new tag of "column-famlily" to its tag set.
2)Validate your answer by 1) executing your solution to q5 again. b) listing all tags used in the database/keyspace c) listing all tags together with their index letters.
the deadline is one day