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.
Conversion used in both mapper snaps:
Error occured for In-Memory Lookup snap :
Can anyone suggest us how to resolve this issue or Is there is any other way to perform lookup between uuid data type columns