Not able to insert in hive partition table

Question

I have created a hive partition table and i check whether it was created properly or not using the description command. I have verified that it was properly created. 

Now I am trying to insert data in the hive partitioned table using the following command:

insert into table partition_table partition(sex='Male')select eid ,name ,age from employee where sex ='Male';

But I am getting this error:

FAILED: SemanticException [Error 10006]: Line 1:44 Partition not found ''Male''

Answer 1

You have to add the partition before you can use it:

ALTER TABLE partition_table ADD PARTITION( sex= 'Male' );
insert into table partition_table partition(sex='Male') select eid ,name ,age from employee where sex ='Male';