cancel
Showing results for 
Search instead for 
Did you mean: 

UUID Lookup in Postgresql

Ranga
New Contributor

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 performing lookup converted uuid column to string using Mapper snap. while validation able to see expected lookup results but when i execute the pipeline In-Memory Lookup snap failed.

Pipeline sample:

image

Conversion used in both mapper snaps:

image

Error occured for In-Memory Lookup snap :

image

Can anyone suggest us how to resolve this issue or Is there is any other way to perform lookup between uuid data type columns

3 REPLIES 3

rreeves
Former Employee

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.

Ranga
New Contributor

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.

rreeves
Former Employee

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.

mapper

Output:

output