Re: How to convert unix timestamp to datetime in Apache NiFi

2019-04-17 Thread Mark Payne
Puspak, For that timestamp given, 01/01/1970 05:30:00.000 is the correct time. I suspect, though, that what you have there is not Unix milliseconds but rather Unix seconds. Try multiplying that by 1000: ${actualarrivaltime:multiply(1000):format("MM/dd/ HH:mm:ss.SSS")} If we use this simple

Latest NiFi customs?

2019-04-17 Thread Russell Bateman
After a couple of years absence from NiFi (prior to Java 9), I find myself just now back in a developer role in a company that uses NiFi. (This is a pleasant thought, I might add, as I believe that NiFi rocks.) I have inherited an existing implementation that's sorely aged and, though I've

How to convert unix timestamp to datetime in Apache NiFi

2019-04-17 Thread Puspak
i have an attribute named "actualarrivaltime" and value as 101600(unixmiliseconds) i want to covert the same to a date fromat . i tried ${actualarrivaltime : format('MM/dd/ HH:mm:ss.SSS')}, but it gives me wrong result . i am getting the value after the conversion is actualarrivaltime

Re: How to pass a flowfile attribute into the query of a getMongo

2019-04-17 Thread Puspak
Thanks for the response -- Sent from: http://apache-nifi-developer-list.39713.n7.nabble.com/

Custom Javascript in UI Without Custom Build

2019-04-17 Thread Peter Wicks (pwicks)
I have some custom Javascript, used for application monitoring, that I'd like to put in the UI. I know how to do this if I'm willing to run a custom build of NiFi. Is there anyway to do this without a custom build of NiFi? My first thought was creating a dummy processor with an Advanced UI,

RE: [EXT] MS SQL CDC Processor

2019-04-17 Thread Peter Wicks (pwicks)
Viresh, There are a couple of options for MS SQL CDC. The "simple" option is to create a view in MS SQL that joins the CDC table with the lsn_time_mapping table. Then use the QueryDatabaseTable processor to load this view incrementally using the "tran_end_time" column. I see you've also

RE: VariableDescriptor exception

2019-04-17 Thread Mark Fursht
From: Mark Fursht Sent: יום ד 17 אפריל 2019 14:27 To: 'iss...@nifi.apache.org' Cc: Ben Yaakobi ; Amir Bareket ; Amir Toledo Subject: VariableDescriptor exception Hello. We have just added NiFi expression language to our app. Today, when I started the application from Intellij IDE, I got an

MS SQL CDC Processor

2019-04-17 Thread Viresh R Navalli
Hi Team, We are looking into CDC for MS SQL, got reference to below link. https://github.com/apache/nifi/pull/2231 I have checked in nifi-1.9.2 release didn't see such processor. Is this functionality available in latest release. _ Thanks & Regards Viresh N