Also LEAD() function can be used with COALESCE() For example    coalesce(sepan, lead(sepan, 1) over (partition by sourcedata order by timestamps)) as sepan   That will replace NULL values in sepan column with next non null value. The timestamps column could be ordered in asc order depending on the value you wan to copy. ... View more

Does any one know why or under what circumstances NIFI passes a null flowfile to a custom NIFI processor ? We are seeing cases where the session that is passed in as an input to the onTrigger method of the custom (java) processor contains a session with a null flow file. ... View more

@Paul Boali just want d3 for ad hoc data visualization ... View more

If there multi characters like '\r\n' for line separator how to handle in serde ... View more