Support Questions
Find answers, ask questions, and share your expertise

Delete record from hive with composite key

I am trying to do a following querey where I need to delete the records that have same 3 columns. However, I can not do the below query. Does anyone have any idea on how I can accomplish it .

delete from cargowise.shipmentdetails where consolid,shipmentid,branch in (select distinct(consolid,shipmentid,branch) from cargowise.shipmentdetails_temp);