0
create table empl(id int,name string) partitioned by (, string);
Insert records into a Partitioned table using VALUES clause.
insert into empl partition(State='Ohio' ) values (1,'Jr Donald');
insert into empl partition(State='Ohio' ) values (2,'Jr Erica');
insert into empl partition(State='Ohio' ) values (3,'Mela');
insert into empl partition(State='Nevada' ) values (10,'Haris');
insert into empl partition(State='Nevada' ) values (11,'Jake');
insert into empl partition(State='Nevada' ) values (12,'Trevor');
Inserting data into Hive Partition Table using SELECT Clause
INSERT INTO empl PARTITION(State) select id,name,state from empl_w;
Insert Overwrite
insert overwrite table empl partition(state) select id,name,state from empl_w;