Merge records in hive

[Raj hadoop]

Hi,



Help required to merge data in hive,



Ex:

Today file

-------------

Empno  ename

1              abc

2              def

3              ghi



Tomorrow file

-----------------

Empno  ename

5              abcd

6              defg

7              ghij





Reg: should not drop the hive table and then create it,what I actually
require is as shown in the example we have to merge the data,



Thanks,

Raj