hadoop - Hive - Insert data into partitioned table: partition not found -

i'm having issue while trying inserting new data in hive external partitioned table.

table partitioned day, error got is:

failed: semanticexception [error 10006]: line 1:51 partition not found ''18102016'' 

my query following:

alter table my_source_table recover partitions; insert overwrite table my_dest_table partition (d = '18102016') select   'iii' primary_alias_type,    iii_id primary_alias_id,    my_source_table     d = '18102016' 

the my_dest_table has been created as:

create external table my_dest_table (    primary_alias_type string,    primary_alias_id ) partitioned (d string) row format delimited fields terminated '\t' location 's3://my_bucket/my_external_tables/' 

any idea on i'm doing wrong? thanks!

i believe should alter table my_source_table recover partitions; destination table.

alter table my_dest_table recover partitions; 

try this.

note: of course should remove comma alex l mentioned. give other parsing error.