Re: Ingest data into SQL database using NiFi

The list of reserved keywords: https://docs.microsoft.com/en-us/sql/t-sql/language-elements/reserved-keywords-transact-sql On Tue, Sep 26, 2017 at 9:31 AM, Koji Kawamura wrote: > Hi Tina, > > I wonder if the column name is the cause of that issue, because 'date' > is a

Re: Ingest data into SQL database using NiFi

Hi Tina, I wonder if the column name is the cause of that issue, because 'date' is a reserved keyword. I wonder whether ConvertJSONToSQL can wrap those columns with square brackets as shown in your example query. If possible, can you try to change the column name to different one such as

Re: [CANCEL] [VOTE] Release Apache NiFi 1.4.0

Mark, I also would like to get RC2 out as soon as possible, but due to time constraints on other tasks, I will not be able to create RC2 until tomorrow afternoon. However, with a 72-hour voting window resulting in binding votes to release RC2, 1.4.0 could be released by the end of the week.

Re: [CANCEL] [VOTE] Release Apache NiFi 1.4.0

Jeff, All outstanding issues have been resolved/committed, right? Can RC2 get turned around quickly? We were hoping to have an official 1.4.0 release by the end of the week. Thanks, Mark On Mon, Sep 25, 2017 at 2:51 PM, Jeff wrote: > Given the issues discovered today, I

[CANCEL] [VOTE] Release Apache NiFi 1.4.0

Given the issues discovered today, I am canceling the voting for RC1. I will prepare RC2 when I get a bit of time to work on it, hopefully within the next day or two, and start another vote thread. Here's a list of issues that will be addressed by RC2:

Re: [VOTE] Release Apache NiFi 1.4.0

Ok good this makes a lot more sense now. One JIRA will fix the erroneous duplicates. And this JIRA, which can be done later, will correct that we should have actually not even have noticed the duplicates and Rick's flow should have worked correctly automatically [1]. [1]

Re: [VOTE] Release Apache NiFi 1.4.0

I think the reason for the upgrade issue was the following... Normally there is an automatic upgrade of component versions, with the following logic: - If the flow says you are using version X of a component, and during startup version X is not found, but version Y is found, and version Y is the

Re: [VOTE] Release Apache NiFi 1.4.0

All, I verified that Joey is correct and that dependency causes the duplicates. I reopened NIFI-4345 and submitted a PR. Regards, Matt [1] https://issues.apache.org/jira/browse/NIFI-4345 [2] https://github.com/apache/nifi/pull/2174 On Mon, Sep 25, 2017 at 11:45 AM, Richard St. John

Re: [VOTE] Release Apache NiFi 1.4.0

Joey, That sounds like that is the issue. Rick. -- Richard St. John, PhD Asymmetrik 141 National Business Pkwy, Suite 110 Annapolis Junction, MD 20701 On Sep 25, 2017, 11:44 AM -0400, Joey Frazee , wrote: > I think there could be an issue with the deps in the  >

Re: [VOTE] Release Apache NiFi 1.4.0

I think there could be an issue with the deps in the nifi-mongodb-services-nar. It includes nifi-lookup-services which should either be unnecessary or should just be provided scope (just need the services API dependency). So it’s possible that all the impls in nifi-lookup-services are indeed

Re: [VOTE] Release Apache NiFi 1.4.0

Joe, The issue I encountered was related to, I believe, the packaging of the mongodb lookup service.  I am using the XMLlookup service and have a processor with a reference to the XML lookup service.  When I upgraded from 1.3 to 1.4, the processor became invalid due to “incompatible type” of

Re: [VOTE] Release Apache NiFi 1.4.0

-1 (binding) based on what Rick ran into. Otherwise though the release is looking good. I'm running through a series of tests now and things going well. Rick, I agree there are duplicate controller services and sourced to the mongo system. And we must fix/remove those. However, the issue for

Re: [VOTE] Release Apache NiFi 1.4.0

-1 non-binding. There are duplicate lookup services registered and it’s causing issues upgrading from 1.3.0 to 1.4.0.  It seems to be related to the mongo lookup service. Rick. -- Richard St. John, PhD Asymmetrik 141 National Business Pkwy, Suite 110 Annapolis Junction, MD 20701 On Sep 24,

Re: [EXT] ConvertCSVToAvro vs CSVReader - Value Delimiter

Hi All, Just raised a PR (https://github.com/apache/nifi/pull/2172) for JIRA NIFI-4416 Appreciate your help, Peter and Matt. Could you please have a quick look and give your comments. Joe - Could you also check out the JIRA and let me know if

Re: Ingest data into SQL database using NiFi

Hi Koji, The "transaction" table only has two columns, "Date" and "Institution". I don't know what else I could change to... Thanks, Tina -- Sent from: http://apache-nifi-developer-list.39713.n7.nabble.com/

回复: How to reinstall NiFi

with the default configuration nfi store all it's data under the install folder (in your case is /opt/nifi). so you can delete '/opt/nifi' and reinstall. Best Regards YuNing 发件人： Lu boying 发送时间： 2017-09-25 19:51 收件人： dev@nifi.apache.org 主题： How to reinstall NiFi Hi, All, I'm using NiFi

How to reinstall NiFi

Hi, All, I'm using NiFi 1.3 (on Ubuntue Linux) and want to clean up all my data in NiFi. My NiFi is installed under /opt/nifi. Is it enough to just deleting everything under /opt/nifi and reinstall it? Thanks Boying