I have a table that looks like this
ohh I just saw hive but this is pretty standard sql give it a try.
SELECT ID FROM TABLENAME GROUP BY ID HAVING COUNT(DISTINCT attribute) = 1
Having is like a where statement after the
GROUP BY aggregation has occurred.