Scenario-9
Have you subscribed for update ? Please subscribe here
Problem Scenario 9 : You already have two tables (Hive) name "SAMPLE_07" and "SAMPLE_08" in a default schema. With following structure (both the tables have same structure).
code string
description string
total_emp int
salary int
Create another table named Employee100K2 in a Family schema, which has all the employees whose salary is >= 100000 from both the tables.
Create required Hive table as below.
CREATE TABLE SAMPLE_08
(code string ,
description string ,
total_emp int ,
salary int
);
INSERT INTO SAMPLE_08 VALUES ('20-0000','All Occupations' ,134354250,40690);
INSERT INTO SAMPLE_08 VALUES ('11-0000','Management occupations' ,6003930,96150);
INSERT INTO SAMPLE_08 VALUES ('22-0000','All Occupations' ,134354250,140690);
INSERT INTO SAMPLE_08 VALUES ('22-1000','Management occupations' ,6003930,99150);
INSERT INTO SAMPLE_08 VALUES ('23-0000','All Occupations' ,134354250,140690);
INSERT INTO SAMPLE_08 VALUES ('23-1000','Management occupations' ,6003930,101150);
Certification Content
Professional HandsOn Trainings
(Lifetime Access and Free upgrades)
ApacheSpark Interview Questions
· Apache Spark InterviewQuestions-1
· Apache Spark Interview Questions-2
· Apache Spark Interview Questions-3
· Apache Spark Interview Questions-4
· Apache Spark Interview Questions-5
· Apache Spark Interview Questions-6
Apache Spark Interview Questions-7
Java MultiThreading Interview Questions
· Java Multi-Threading Intrview Questions-1
· Java Multi-Threading Interview Questions-2
· Java Multi-Threading Interview Questions-3
· Java Multi-Threading Interview Questions-4