Member since
10-15-2020
11
Posts
0
Kudos Received
1
Solution
My Accepted Solutions
| Title | Views | Posted |
|---|---|---|
| 1571 | 11-04-2020 05:46 AM |
11-04-2020
05:46 AM
Came up with a fix for this as it was a text file - to splittext each line (1) at the beginning before converting to a JSON file. (think it was the only way to do this as couldn't split after).
... View more
11-02-2020
07:29 AM
I am trying a ParseCEF & a ParseSysLog processor with a text file and it falls down at the point of Parsing wrt only seeing the first line and then stopping. Are there any examples of parsing a text file to JSON and also recognising the multiple lines after the Parse processor so that there are multiple lines but in the same file. (I realise you can do a SplitText processor before the Parsing, but don't want to go this route.
... View more
10-29-2020
07:54 AM
Thanks, I am trying some stuff now to parse data using the JoltSpec/JoltTransformJSON processor that could help me with this issue, but thanks for this help, hopefully can get things running more smoothly soon. 🙂
... View more
10-29-2020
03:20 AM
Thanks, I cant put any data up here, but I think we are getting close. I can pull all data through which then marries it up with the schema, so it is formatted as data associated with the schema. I am then wondering how I can then add another QueryRecord Processor below which I can then add individual sql lines which can pull out coloumns from this data, ie SELECT *, FROM FLOWFILE WHERE table_name = 'rt'
... View more
10-27-2020
08:09 AM
I am trying to reference an Avro Schema that already works from a CEF file and take out a part of that file (time as rt) by referencing the Schema, but I am a bit rusty with my SQL so it's not going to plan rn - does anyone have any examples of doing this in NiFi?
... View more