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''