Hi Im loading a csv file via NiFi process, PutDatabaseRecord. What I found is that on one of the fields, the data for that Boolean field is either True or False. After running this PutDatabaseRecord process and check the table. The value is actually loaded as 1 or 0 instead of True or False.
Is there way to stop this conversion ie load it as is True or False? How? The Avroscheme registry as per highlighted in yellow: { "type": "record", "namespace": "com.example", "name": "N_RIM_ACCOUNTS", "fields": [ {"name": "account", "type": ["null", "string"]}, {"name": "account_type_ID", "type": ["null", "string"]}, {"name": "account_description", "type": ["null", "string"]}, {"name": "account_active_boolean", "type": ["null","string"]}, {"name": "account_valid_boolean", "type": ["null", "string"]}, {"name": "account_affiliation", "type": ["null", "string"]}, {"name": "account_pending_boolean", "type": ["null", "string"]}, {"name": "account_start_date", "type": ["null", "string"]}, {"name": "account_stop_date", "type": ["null", "string"]} ] } Your assistance in this matter would be greatly appreciated. Phuc Nguyen Senior Integration Developer, Data and Identity Services Information Technology Services The University of Queensland Brisbane Qld 4072 Australia T +61 400 284 649 E phuc.ngu...@uq.edu.au<mailto:phuc.ngu...@uq.edu.au> W uq.edu.au<http://www.uq.edu.au/> CRICOS code: 00025B [cid:image001.jpg@01D8B6EB.87CEDAC0] The University of Queensland is embracing the Green Office philosophy. Please consider the environment before printing this email. This email (including any attached files) is intended solely for the addressee and may contain confidential information of The University of Queensland. If you are not the addressee, you are notified that any transmission, distribution, printing or photocopying of this email is prohibited. If you have received this email in error, please delete and notify me. Unless explicitly stated, the opinions expressed in this email do not represent the official position of The University of Queensland.