RE: Nifi 1.15.2 and 1.15.3 compilation errors

2022-01-20 Thread Michal Tomaszewski
Thank you very much for explanation. Regards, Mike -Original Message- From: Joe Witt Sent: czwartek, 20 stycznia 2022 19:36 To: users@nifi.apache.org Subject: Re: Nifi 1.15.2 and 1.15.3 compilation errors Mike Yeah a bit more than two years ago we stopped including the nifi-kite-nar

Re: Nifi 1.15.2 and 1.15.3 compilation errors

2022-01-20 Thread Joe Witt
Mike Yeah a bit more than two years ago we stopped including the nifi-kite-nar by default. https://cwiki.apache.org/confluence/display/NIFI/Migration+Guidance That means the processors in it are no longer included by default. Since that time though we still build and published the nar to maven

Re: Nifi 1.15.2 and 1.15.3 compilation errors

2022-01-20 Thread Chris Sampson
If the kite nar is refined then that processor would indeed no longer be present. A good alternative would be to use a Record based processor such as ConvertRecord with a CSVReader and an AvroWriter. Such processors and controller services typically offer much more powerful options than the older

RE: Nifi 1.15.2 and 1.15.3 compilation errors

2022-01-20 Thread Michal Tomaszewski
Joe, Does it mean ConvertCSVToAvro will disappear too? Or you discontinue only a part of org.apache.nifi.processors.kite schema and the rest will be somehow moved to other schemas? Regards, Mike From: Joe Witt Sent: środa, 19 stycznia 2022 15:57 To: users@nifi.apache.org Subject: Re: Nifi

RE: PutSQL in combination with ConvertJSONToSQL gives java.sql.SQLException: Invalid column type for Orcale DataType BINARY_DOUBLE

2022-01-20 Thread Sven Ritter
Hello Matt, Thanks for the information. Disabling the quotes did the trick. Thanks Sven -Original Message- From: Matt Burgess Sent: Thursday, January 20, 2022 5:28 PM To: users@nifi.apache.org Subject: Re: PutSQL in combination with ConvertJSONToSQL gives java.sql.SQLException:

Re: NiFi V1.15.2 Conversion to Avro from JSON

2022-01-20 Thread nathan.english
Hey Mark, You beat me to the fix, Thanks for taking your time to look at it! I appreciate that one. Cheers! Nathan From: Mark Payne Sent: Wednesday, January 19, 2022 6:54:23 PM To: users@nifi.apache.org Subject: Re: NiFi V1.15.2 Conversion to Avro from JSON

Re: PutSQL in combination with ConvertJSONToSQL gives java.sql.SQLException: Invalid column type for Orcale DataType BINARY_DOUBLE

2022-01-20 Thread Matt Burgess
Sven, This is a recently discovered bug, I am still working on characterizing the issue before writing a Jira to describe it. NIFI-9169 [1] has the same cause but is a slightly different issue. So far the issue seems to be with using update key(s) with "Quote Identifiers" set to true. Setting it

RE: PutSQL in combination with ConvertJSONToSQL gives java.sql.SQLException: Invalid column type for Orcale DataType BINARY_DOUBLE

2022-01-20 Thread Sven Ritter
Hi Mark, Thanks for the hint with the PutDatabaseRecord processor. I tried it. For INSERTS it works fine, but the UPDATE is failing with: “Routing to failure.: ORA-00936: missing expression”. When I enable DEBUG and force the processor to write out the SQL query (by setting Maximum Batch

GenerateTableFetch 1.15.0 MySQL exception incorrect?

2022-01-20 Thread Hendrik Ruijter
Hello, the use case is to iterate over MySQL shards with empty tables by GenerateTableFetch 1.15.0. The JDBC used is mysql-connector-java-8.0.21.jar. The comment and exception do not seem to be correct since MySQL does return 0 rows (Empty result set fetched). GenerateTableFetch.java:432