Member since
09-02-2018
5
Posts
0
Kudos Received
0
Solutions
09-07-2018
04:59 PM
Tons of thanks Shu , I was struggling to find the solution for last 2 days doing all nonsense things like turning off \" in short escape sequencing and others but did not work at all. Thanks again
... View more
09-07-2018
02:17 PM
Dear Community, I have to extract the data from MSSQL table and one of the table has quoted and special characters in the table column names as per below details select "1stWelcomePackageSentDate",
"1stWelcomePackageSentValue",
"2ndReviewDate",
"2ndReviewValue",
"2ndWelcomePackageSentDate",
"2ndWelcomePackageSentValue",
AssignedCloser,
AssignedCloserUpdated,
AssignedOpener,
AssignedOpenerUpdated,
AssignedTo,
AssignedToUpdated,
AssignedUnderwriter,
AssignedUnderwriterUpdated,
BorrowerConfirmationLetterSentDate,
BorrowerConfirmationLetterSentValue,
"Completed/signed4506TDate",
"Completed/signed4506TValue", When I execute <select * from XYZ table> in ExecuteSQL nifi Processor it throwing error as below SchemaParserException : illegal initial character in 1stWelcomePackageSentDate Considering <select * form XYZ> may be an issue then I tried MS_SQL [] bracket column name SQL format as per below even though it has same error SELECT [1stWelcomePackageSentDate]
,[1stWelcomePackageSentValue]
,[2ndReviewDate]
,[2ndReviewValue]
,[2ndWelcomePackageSentDate]
,[2ndWelcomePackageSentValue]
,[AssignedCloser]
,[AssignedCloserUpdated]
,[AssignedOpener]
,[AssignedOpenerUpdated]
,[AssignedTo]
,[AssignedToUpdated]
,[AssignedUnderwriter]
,[AssignedUnderwriterUpdated]
,[BorrowerConfirmationLetterSentDate]
,[BorrowerConfirmationLetterSentValue]
,[Completed/signed4506TDate]
,[Completed/signed4506TValue]
,[CompletePcgReceivedDate] From <TABLE> Please help me how to solve this special characterized DB column names in NIFI Thanks Kamlesh @kkpant75
... View more
Labels:
- Labels:
-
Apache NiFi
09-04-2018
03:25 PM
change <Use Avro Logical Types==>true>
... View more