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 <[email protected]>: > 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 <[email protected]> > : > >> 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 >> >> >
