Analyze the MovieLens dataset to identify popular genres using Hive over Hadoop in Cloudera VM. Extract insights for streaming platforms like Netflix or Prime.

• Apache Hive
• Hadoop HDFS
• Cloudera Quickstart VM
• Linux Shell
• Excel / Matplotlib for visualization

• Genre-wise popularity using Hive explode and split
• Data stored and queried in HDFS
• Business insights for recommendation engines
• Visualization charts

• datasets/: Input CSV files
• Hive_Queries/: All Hive scripts
• visualizations/: Graphs generated from output and Hive CLI output proofs

See Movie analytics.docx for the full write-up.

1. Set up Cloudera VM
2. Load movies.csv into HDFS
3. Create external Hive table
4. Run queries from hive_queries/