Hello Experts,
when i try to execute the below query i'm getting error. Please help me to
correct this.
insert overwrite table table_baseline partition (sourcedate='base_2013_08')
select * from (select * from table_a where sourcedate='tablea_2013_08' union
all select * from table_b where sourcedate='tableb_2013_08') final
My intention here is i want to populate the table_baseline by using the all
records from table_a and table_b with partition. I am getting the below error.
Error in semantic analysis: Line 1:23 Cannot insert into target table because
column number/types are different ''BASE_2013_08'': Table insclause-0 has 62
columns, but query has 63 columns.
I verified the column count and types everything is same but here it says some
difference. The same query works fine without having any partitions in all the
three tables but getting error while executing with partitions.
please help.
ThanksManickam P
