Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started