Member since
06-08-2017
1049
Posts
518
Kudos Received
312
Solutions
My Accepted Solutions
| Title | Views | Posted |
|---|---|---|
| 11133 | 04-15-2020 05:01 PM | |
| 7031 | 10-15-2019 08:12 PM | |
| 3075 | 10-12-2019 08:29 PM | |
| 11275 | 09-21-2019 10:04 AM | |
| 4193 | 09-19-2019 07:11 AM |
05-20-2018
12:29 PM
@Amira khalifa You are having timestamp column format as 2008:05:17 17:23:01(with colon delimiter). Use the ReplaceText processor with below configs Search Value
(\d{4}:\d{2}:\d{2})(\s+)(\d{2}:\d{2}:\d{2})
Replacement Value
'$1$2$3'
Character Set
UTF-8
Maximum Buffer Size
1 MB //change the value as per your flowfile size
Replacement Strategy
Regex Replace
Evaluation Mode
Entire text Input Flowfile: 2008:05:17 17:23:01 --other fields Outputflowfile: '2008:05:17 17:23:01' --other fields - If the Answer helped to resolve your issue, Click on Accept button below to accept the answer, That would be great help to Community users to find solution quickly for these kind of issues.
... View more
01-31-2019
02:22 PM
@Shu , can you upload xml for recent solution , @shu can you upload .xml file here for recent flow
... View more
05-16-2018
11:31 AM
Thank you @Shu again! I didn't know that attributes where accessible over the flow to use them later. I use the first approach.
... View more
06-18-2019
12:55 PM
@Shu - Thanks for your detailed answer. That helps. What if I have a timestamp and I need to convert it to a string?
... View more
05-18-2018
12:43 PM
@Shu Sorry for the late response .The flow worked fine.As mentioned the unpack processor recursively extract all the files.When I make sample zip file it works fine.But unfortunately the ZIP file I have to work with has a descriptor.This cause the processor to fail and gives an unsupported feature exception.As workaround I am planning to write a script and call it via execute script processor.Will keep you updated on my progress
... View more
05-14-2018
04:43 AM
Thank you Shu. it works
... View more
05-14-2018
11:23 AM
Dear @Shu it worked perfectly, concept was simple but great, thank you !!
... View more
05-12-2018
01:10 PM
@adam chui
We are not able execute commands in ExecuteStreamCommand processor like [bash] cat <filename>|grep <search string> (or) [bash] ls |wc -l But you can use QueryRecord processor and write the sql query(to filter or count..) then the query is going to be executed on the contents of the flowfile. Take a look into this link for more details regarding Query Record processor.
... View more
05-11-2018
11:32 AM
1 Kudo
@Shu you are awesome. Thanks for the help. It does resolve my problem. I wanted to make rowkey using the combination of json attributes, in order to achieve I used updateAttribute processor and declared the key there using the combination of resource id, metric id and timestamp. Then included this rowkey in AttributesToJson.
... View more
05-11-2018
01:18 AM
1 Kudo
Hi @Shu Thanks - this is now fixed. We realized the Nifi Nodes werent added to the hadoop topology which is why we were getting that error. This has been added and the data is going through !! Thanks for all the help .. Have accepted your answer ..
... View more