Question: Please write your answers (queries) for the following two questions: In Hive, please create a table called employees with four columns: column essn (employee SSN)
Please write your answers (queries) for the following two questions:
- In Hive, please create a table called employees with four columns:
- column essn (employee SSN) has type String
- column name has type String
- column dependents has type map, key is relationship(String), value is dname (dependent name) (String)
- column salary (float)
- In the employees table, for column dependents, for the relationship field, there can be only two values either child or spouse. Please write a query statement in hive to extract all employees child dependents names. In the result, we need to have two columns: essn, name of child dependent.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
