Support Questions
Find answers, ask questions, and share your expertise

Nifi converts UUI (nvarchar) to a number

New Contributor

Hi everyone!

 

Nifi is doing something strange with my data.

I'm moving the data from SQL Server to a SQL Server using Nifi.

 

the flow is simple 

1. QueryDatabaseRecord 

1.1 Record Writer: JsonRecordsSetWriter

2.SplitJson

3.convert json to sql 

4. put sql

I have a column with this value: 024b2390-fecb-4b23-b057-e4e9cd8e32d3 as nvarchar in sql server

and nifi read that value and convert it to: 20210224150351135

 

strange enough I also have another record having this value: d2278af1-f2ed-4959-849b-bcb1ef7f496a and Nifi were able to read it as is without any issue.

 

I want to move the data without any change.

 

Thank you all in advcance.

 

 

0 REPLIES 0
Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.