Hi all, I have this scenario to remove certain rows from a hive table. As far as I understand, hive doesn't provide that functionality.
So, I'm trying to select inverse of what I want to delete and overwrite the table with that. What do you think of this approach? I tried to do it but seems it doesn't work as I expect. All data is still available in the table. what's the reason if it's the correct behavior? Thanks.