Aruna,
You would need to remove the commas from the number. The easiest way to do that
is probably to use
an UpdateRecord processor before the PutDatabaseRecord. In that processor, you
would want to use a
schema that either declares the field as a "string" or uses a union like:
{ "name" : "NUMBER_OF_PRESCRIBERS", "type": [ "int", "string" ] }
Then, in UpdateRecord you would add properties such as:
/NUMBER_OF_PRESCRIBERS = replace(/NUMBER_OF_PRESCRIBERS, ',', '')
That would strip out any commas for you. It looks like you would need to do the
same for each of the fields
here that you are declaring as an "int"
Thanks
-Mark
On Dec 14, 2017, at 11:15 AM, Aruna Sankaralingam
<[email protected]<mailto:[email protected]>>
wrote:
I am getting this error when I am trying to load a csv to redshift. I guess its
because I declared that as an INT in AvroSchema and the value has a “,”. If so,
how do I make it accept that as an integer?
<image001.png>
<image002.png>
<image003.png>
