I know that this was discussed before, but I couldn't find the answer, so I decided to post this question again to see if someone has a solution.
Our application is inserting a lot of data and they have been using Timestamp as a unique row identifier for a long time. Some time ago they received several duplicates and converted their code to " SELECT ((TIMESTAMP(GENERATE_UNIQUE()))". This has worked for several years, but last week they noticed duplicates again. I understand that the current approach doesn't guarantee uniqueness. Can someone suggest a better way of generating a Unique Timestamp? The application team doesn't want to change their code and they insist on using Timestamp for uniqueness.