Scenario-8

Have you subscribed for update ? Please subscribe here

Problem Scenario 8 : You already have a table name "SAMPLE_07" in a default schema. With following structure.

code string

description string

total_emp int

salary int

Sample data as below.

sample_07.code sample_07.description sample_07.total_emp sample_07.salary

00-0000 All Occupations 134354250 40690

11-0000 Management occupations 6003930 96150

Create Hive table and data as below.

CREATE TABLE SAMPLE_07

(code string ,

description string ,

total_emp int ,

salary int

);

INSERT INTO SAMPLE_07 VALUES ('00-0000','All Occupations' ,134354250,40690);

INSERT INTO SAMPLE_07 VALUES ('11-0000','Management occupations' ,6003930,96150);

INSERT INTO SAMPLE_07 VALUES ('02-0000','All Occupations' ,134354250,140690);

INSERT INTO SAMPLE_07 VALUES ('12-0000','Management occupations' ,6003930,99150);

INSERT INTO SAMPLE_07 VALUES ('03-0000','All Occupations' ,134354250,140690);

INSERT INTO SAMPLE_07 VALUES ('13-0000','Management occupations' ,6003930,101150);