Step 1: Create Dataset 
%%writefile student_data.csv 
101,Amit,Data Science,85 
102,Neha,AI,90 
103,Rahul,Big Data,78 
104,Priya,Machine Learning,88 
105,Kiran,Data Analytics,92 
Step 2: Install Java 
!apt-get install openjdk-8-jdk-headless -qq > /dev/null 
Step 3: Download and Extract Hadoop 
!wget -q https://downloads.apache.org/hadoop/common/hadoop-3.3.6/hadoop
3.3.6.tar.gz 
!tar -xzf hadoop-3.3.6.tar.gz 
Step 4: Download and Extract Hive 
!wget -q https://downloads.apache.org/hive/hive-3.1.3/apache-hive-3.1.3
bin.tar.gz 
!tar -xzf apache-hive-3.1.3-bin.tar.gz 
Step 5: Create Hive Table 
Hive Query: 
CREATE TABLE student( 
id INT, 
name STRING, 
course STRING, 
marks INT 
) 
ROW FORMAT DELIMITED 
FIELDS TERMINATED BY ','; 
Step 6: Load Data into Hive Table 
LOAD DATA LOCAL INPATH 'student_data.csv' 
INTO TABLE student; 
Step 7: Display Table Data 
SELECT * FROM student; 
Step 8: Query Students with Marks > 85 
SELECT * FROM student 
WHERE marks > 85;