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 [email protected]<mailto:[email protected]> W
uq.edu.au<http://www.uq.edu.au/>
CRICOS code: 00025B
[cid:[email protected]]
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.
