UUID Lookup in Postgresql
Hi,
I have a requirement to perform lookup between uuid data type columns. Used PostgreSQL - Lookup snap but getting data type mismatch issue. Later replaced with In-Memory Lookup snap, before perf...
Forum Discussion
This was a known issue with java.util.UUID types and the In-Memory Lookup Snap in the 4.11 release that has been patched. Subscribing to the latest transform Snap Pack release should fix the issue you are seeing.
can we convert UUID datatype to other formats and achieve this? If possible can you suggest which data type conversion is suited for this requirement.
Here is a workaround using the Mapper Snap to convert the java.util.UUID objects to strings. Make sure to select “Pass through” so that non-transformed input fields are also included in the mapper output document.
Output:
