Install hive on Ubuntu on a VM$,$ set up all required configuration, and then do the following:

Make the following table:

student no$.$ student name course Mark

$2011202$ Simon L$.$ A$01191$

$2011202$ Simon L$.$ B$03295$

$2011201$ Lana R$.$ A$01186$

$2011201$ Lana R$.$ B$03272$

$2011153$ Justin O$.$ A$03172$

$2011341$ Sam H$.$ C$07670$

$2011202$ Simon L$.$ C$07685$

Show the table

Add a new record for $2011203,$ Sara M$.,$ A$011,50$

Show the new table

Replace marks $72$ with $82$

Delete the record with course# A$011$

Show records for Simon with marks $>90$

Show the highest mark for each student

List all courses without repetition