Get the latest record from a table based on some columns and insert in another table in hive.
I am trying to get the latest record from src_table based on name and id columns and insert in my tgt_table.
I can use date column also.
Please help me with code as i am new to hive.
Thanks in advance.