Removing Duplicates from Comma-Separated Values in Hive

How to Shift Rows of a Date Column According to a Group Category in Hive Using LAG Function