Hi, We have a requirement to delete records from hive table based on some condition. and we need to make sure that in future if the data will come with same ID it should not be inserted. For deletion one approach is to load the required data in another table delete the original one and rename the new one. But how will we ensure that in future if the data will come with same ID it should not be inserted. Please suggest some new and optimized approach for deletions if any. Thanks. ... View more