Partitioned Hive Table Insert Syntax

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;