Hello, My source DB and destination DB both are same --> Postgres Please look at the problem and let me know if you have any solution regarding the issue.
Thankyou -Deepanshu ________________________________ From: Matt Burgess <mattyb...@apache.org> Sent: Friday, October 25, 2024 1:52:42 am To: users@nifi.apache.org <users@nifi.apache.org> Subject: Re: Issues with Inserting Boolean Data into Bit Data Type Column Deepanshu, I couldn't reproduce this with MySQL, I was able to put a boolean value into a Bit(1) column without error. What DB are you using for your target table? Regards, Matt On Thu, Oct 24, 2024 at 5:14 AM Deepanshu Lodhi <deepansh...@inventia.in<mailto:deepansh...@inventia.in>> wrote: Hi Everyone, I hope you’re all doing well! I'm experiencing issues when trying to insert Boolean values (true, false) into a Bit(1, 0) datatype column using the PutDatabaseRecord processor. The source table contains a column of Bit datatype; however, the Avro logical type, along with the Avro reader and other readers (like JSON/CSV) in QueryDatabaseTable and PutDatabaseRecord respectively, fetch the records as Boolean by default. Could anyone provide assistance on how to properly insert Boolean data into a Bit column? Thank you in advance for your help! Best regards, Deepanshu
