Hi Geoffrey , Thanks for the suggestion . I am using ORC format for both table. it is only the sequence of the column that is causing the issue .
EG:
A(name string,sal decimal(3,2),DOB timestamp)
B(name String , DOB Date, sal decimal(3,2))
When i insert data from B to A using a select query i am getting this error.
if i drop table A and create it in the same sequence as of B it works fine.
Is there a solution which can be applied here to force hive to insert data based on name of column instead their Sequence .