nifi-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From françois lacombe <>
Subject Re: [Nifi 1.5] PutDatabaseRecord and pgsql integer fields
Date Mon, 09 Apr 2018 09:10:59 GMT
Hi Pierre,

Thank you for your input
Schema certainly is a key point here. I used a CSVReader with Use Strings
Fields from Header as access strategy.
Moving access strategy to a text-defined schema solve the issue

On side question: in the schema, what are fields name relative to, csv
header or pgsql table?

All the best

François Lacombe

2018-04-09 10:47 GMT+02:00 Pierre Villard <>:

> Hi François,
> How did you define your schema in the PutDatabaseRecord processor?
> If you're using a CSV Reader and infer the schema using the header, then
> all the fields will be considered as strings.
> You probably want to define the schema by yourself so that you can define
> the type of each column of your CSV file.
> Pierre
> 2018-04-09 10:44 GMT+02:00 françois lacombe <>
> :
>> Hi all,
>> This is my first mail on this feed, as I've discovering NiFi a few days
>> ago.
>> I'm working for a company involved in software development for utilities
>> networks operators
>> One of my first use case to test NiFi is to load a csv file in an
>> existing pgsql table, which sounds like a pretty common thing.
>> I'm currently facing issues with integer fields. My csv file contains
>> numbers and I use GetFile processor to load and PutDatabaseRecord seems to
>> quote values with single quotes.
>> PgSQL doesn't like it at all and raise errors (column is of type numeric
>> but expression is of type character varying
>> How can I prevent PutDatabaseRecord process to quote my numeric values?
>> Thank you in advance for answers, best regards
>> François Lacombe

View raw message