When i run insert overwrite from B to table A having all column present but not in the same sequence , i am getting a conversion error. IS there a solution available where we can force the insert by name of column insted of sequence.
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 .
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 .