About johnascarey

johnascarey · ‎03-15-2021

@TimothySpann As an example you can consider the below example json object, { "car1":"Ford", "car2":"BMW", "car3":"Fiat", "car4":"Mercedes", "car5":"Ferrari" "car6":"Nissan" } Essentially, my table should be having 6 records in total. The values of first column should be car1, car2,........,car6 and the values of second columns should be Ford, BMW, Fiat, Mercedes, Ferrari, Nissan

johnascarey · ‎03-15-2021

Hello, After flattening a complex nested json to a flat json using the FlattenJson Processor, I want to load all the keys and values of that flat json to two separate columns of a table in database. What is the most efficient way to achieve this in Nifi? Thanks in advance @TimothySpann @mburgess @bbende

johnascarey · ‎02-22-2021

Hello, I am trying to download a nifi template which has around 260 processors. Whenever I try to download the template in chrome browser, the downloading stops after 320kb and throws me an error which says "Failed - Network Error". Since there are around 260 processors, it is understandable that the template size is considerably big however I can download other smaller templates from the same Nifi instance. I even tried downloading the template with other browsers but the error is same. Is there any configurations which needs to be done from the server side? Any insights are appreciated @mburgess @bbende @TimothySpann

johnascarey · ‎02-14-2021

Hi @mburgess Can you please elaborate on which property needs to be configured in the GrokReader controller service for using the kv filter? I'm trying to parse the incoming key=value pair. Input: key1=value1,key2=value2,key3=value3,key4=value4 output: I need key1, key2, key3, key4 as attributes and their respective values as attribute values I can use %{GREEDYDATA:msgbody} in the GrokExpression property but I do not know where to provide kv { source = "msgbody" } Your help is appreciated

johnascarey · ‎02-07-2021

Hello all, I am newbie in Grok Expressions and need some help with the same in Nifi. I am trying to capture key=value pairs of log messages coming from Kafka using Grok Expressions in Nifi using the ExtractGrok Processor or the GrokReader Controller service. Eventually all the keys are the column names in a table and their corresponding values will be in fact the values of the same columns in the same table. Here is how a sample message looks like. Field1=value1, Field2 = value2,...................................................... Any help from anyone would be appreciated. Thanks @mburgess @bbende

johnascarey · ‎02-04-2021

Hello @mburgess Can you please answer the above question from VidyaSargur?

Online	Offline
Last Visited	‎03-22-2022 07:54 AM

Member Since	‎11-25-2020 11:38 AM
Last Visited	‎03-22-2022 07:54 AM
Posts	8
Kudos received	2

Cloudera Community

Re: Converting Keys and values of a flat json to t...

Converting Keys and values of a flat json to two s...

Unable to download Nifi Template: Failed - Network...

Re: Nifi: KV filter

Grok Patterns/Expressions for capturing comma sepa...

Re: Nifi: KV filter