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 <[email protected]> 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 > > >
