Member since
12-17-2016
106
Posts
11
Kudos Received
0
Solutions
07-24-2017
12:39 PM
Thanks Matt Clarke
... View more
07-24-2017
12:38 PM
Thanks Matt Clarke
... View more
07-24-2017
12:38 PM
Thanks Matt Burgess
... View more
07-24-2017
12:29 PM
Thanks Sonu Sahi
... View more
07-14-2017
06:29 AM
I am using HDP 2.5 and NiFI-1.1.0.2.1.2.0
... View more
Labels:
- Labels:
-
Apache NiFi
06-23-2017
07:07 AM
I try convert ingect json file into postgresql for that first i try to convert my json file into sql format by using ConvertJSONToSQL processor, after that I pass flow into replacetext processor and after that I make flow into putsql processor. In putsql processor I got issue "Due to org.postgresql.util.PSQLException: The column index is out of range: 1" NIFI Flow PutSQL Error: PutSQL processor configuration ReplaceText processor configuration Replacement Value: "INSERT INTO public.detail (id,name, salary) VALUES (${id},${name},${salary})" ConvertJSONToSQL processor configuration
... View more
Labels:
- Labels:
-
Apache NiFi
06-15-2017
12:08 PM
Thanks Matt Clarke
... View more
06-15-2017
12:07 PM
Thanks Matt Burgess
... View more
06-14-2017
08:09 AM
1 Kudo
I try to access a postgresql through Nifi for that first I try to get json from RestApi through GetHTTP processor, then I try to insert json into postgres through convertJSONToSQL processor in nifi. While initializing DBCP connection I got "DBCPConnectionPool[id=27273afd-ed82-48f4-aaae-d9f265d72769] Failed to invoke @OnEnabled method due to org.apache.nifi.reporting.InitializationException: Can't load Database Driver". I attach my DBCPconnectionpool configure controller service below.
... View more
Labels:
- Labels:
-
Apache NiFi
06-07-2017
09:28 AM
Yes, I create a separate directory in local and import PostgreSQL driver jar into it. After that I point to its location into "Database Driver Jar URL" property, but still I got issue that I mention below.
... View more