Member since
10-16-2019
23
Posts
1
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
2974 | 10-21-2019 05:17 AM |
03-08-2020
09:06 PM
We are tying to insert data to pstgresql table using PutDatabaseRecord processor in Apache-NiFi.
In that we get
cannot create poolableconnectionfactory(fatal role postgres does not exist )
is this completely related to PostgreSQL(as describe below) or do we need to change some conf in NiFi side?
psql-fatal-role-postgres-does-not-exist
psql: FATAL: database “<user>” does not exist
... View more
Labels:
- Labels:
-
Apache NiFi
12-04-2019
07:30 PM
Sorry, I havent use AVRO, as my scenario entirely based on csv data. I think posting a new question may give attention from community.
... View more
10-21-2019
05:17 AM
1 Kudo
I have fixed this issue with the help of my supervisor. I have used only two processors. GetFile and PutDatabaseRecord. Two changes made for `PutDatabaseRecord` Processor 1) Schema name : public 2) Translate field names : false Also didnt use AVRO reader. I hope this would help someone.
... View more
10-16-2019
03:23 AM
I am trying to read a csv file and put those records into a postgres table. To do it, I have used some tips given Loading a simple CSV file using nifi.
My template is :
GetFile -> UpdateAttribute -> PutDatabaseRecord
In UpdateAttribute I have used `schema.name` -> `postgres database`
In PutDatabaseRecord ->
CSVReader
AvroSchemaRegistry
DBCPConnectionPool
My CSV file
```
userid,username
1,'sachith'
```
When I put this to my source folder, it goes to PutDatabaseRecord and gives following error
> None of the fields in the record map to columns defined by the nifi.nifiTest table.
First I used MySQL just with GetFile -> PutDatabaseRecord, it was working properly without error.
What am I missing here? I am pretty new for Nifi.
... View more
Labels:
- Labels:
-
Apache NiFi