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

Searched deletes is not working in Hive ACID

I have an external table "shipmentprofile_temp" which has the list of keys that needs to be deleted from my transnational table "shipmentprofile"

I am executing below query that executes but does not complete.

delete from cargowise.shipmentprofile
where transcnno in (select transcnno from cargowise.shipmentprofile_temp);