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.


Reply via email to