Create a Hive table by name web series with different columns as shown in the table in and write HiveQL for the following. Write the HiveQL to display the movies that have rating below 9. Write the HiveQL to determine the number of movies an actor "S" has acted from the table

1) Create a file in the following format (06Marks) Name Rating Actor Actress Rating Familyman 9.5 Mirzapur 8.9 Monster 8.6 Create a Hive table by name web series with different columns as shown in the table in and write HiveQL for the following. Write the HiveQL to display the movies that have rating below "9". Write the HiveQL to determine the number of movies an actor "S" has acted from the table. 1) Create a file in the following format (06Marks) Name Rating Actor Actress Rating Familyman 9.5 Mirzapur 8.9 Monster 8.6 Create a Hive table by name web series with different columns as shown in the table in and write HiveQL for the following. Write the HiveQL to display the movies that have rating below "9". Write the HiveQL to determine the number of movies an actor "S" has acted from the table