I haven't found any solutions to the problem (tried Hive CLI and HUE query editor). I will try to do a workaround...
What do you mean by "prerequisites"?
Deletes can only be performed on tables that support ACID. More over your tables's file format should be ORC
Below are the properties that needs to be set .
hive.support.concurrency true (default is false) hive.enforce.bucketing true (default is false) (Not required as of Hive 2.0) hive.exec.dynamic.partition.mode nonstrict (default is strict)
Also i would suggest you to take look into kudu.