In non partitioned table I am getting the correct values. Is my update query wrong?
1. INSERT OVERWRITE TABLE Unm_Parti_Trail PARTITION (Department = 'A') SELECT employeeid,firstname,designation, CASE WHEN employeeid=19 THEN '50000 ELSE salary END AS salary FROM Unm_Parti_Trail; What I tried to include in the query is , In partion with department = A, update employeeid =19 's salary with 50000 Is that query statement wrong? and the replication is not affected to dept B and C. -- *Thanks & Regards * *Unmesha Sreeveni U.B* *Hadoop, Bigdata Developer* *Centre for Cyber Security | Amrita Vishwa Vidyapeetham* http://www.unmeshasreeveni.blogspot.in/
