I have a hive table to which new partitions get added (say daily). And I want to write a daily hive query that tells me which records changed or were added that day. A unique record is a combination of multiple columns. Would using hive's hash or sha (with 256) udf be the best and most performant route to writing such a query? And will using a 256 hash be good enough to prevent collisions? ... View more