About MWM

MWM · ‎10-17-2023

@cotopaul I write correct syntax but it didn't work 😕 But in UpdateRecord processor Replacement Value strategy should be on Literal Valu or Record Path Value?

MWM · ‎10-17-2023

@cotopaul and without this property UUID now is like that: [118, 90, 123, 96, -61, 100, -20, 76, -89, -95, -64, -105, -43, -106, -111, 69]

MWM · ‎10-17-2023

@cotopaul are you sure this property should look like this : because it didn't work, UUID_1 now look like this : "UUID_1" : ":toString(/UUID_1,\"UTF-8\")"

MWM · ‎10-17-2023

@cotopaul how can I set this schem in AvroWriter?

MWM · ‎10-17-2023

@cotopaul I used Intellij and have something like that: { "type" : "record", "name" : "USERDATA", "namespace" : "any.data", "fields" : [ { "name" : "Name", "type" : [ "null", "string" ] }, { "name" : "Surname", "type" : [ "null", "string" ] }, { "name" : "Mail", "type" : [ "null", "string" ] }, { "name" : "UUID_1", "type" : [ "null", "bytes" ] }, { "name" : "City", "type" : [ "null", "string" ] } ] } but the column in the data is apparently of type Stryng - it is not my database, I only have access to the views and download them

MWM · ‎10-17-2023

@cotopaul thank you for your answer, can you tell how can i open this file in AvroReader-should I do it in Nifi?Sorry for my question but I am totally new in NIFI...

MWM · ‎10-17-2023

Hi @cotopaul Basically, my flow looks like this: first I use QueryDataTable to download the view from the database, then I have the ConvertAvroToJson processor but I don't have anything filled in the AvroSchema field because everything except the UUID field is converted, in the database the UUID appears as a String

MWM · ‎10-15-2023

Hi, I have the following problem - I download data from the database using QueryDatabaseTable, I receive the data in the avro-binary format, so then I use ConvertAvroToJson - everything converts nicely except the UUID field, I am left with the following json: { "Name":"Mary", "Surname":"Smith", "Mail":"m.smith@google.com", "UUID":{ "bytes":"_ìª¨Ô¸¬I³Sñ])º\u000E•" }, "City":"New York" } I tried to extract this UUID as an attribute and replace it with the :toString() method but it doesn't work, does anyone have an idea how to convert it to a string?

MWM · ‎10-02-2023

Hi, I have the following problem, I have a flow that uses the Mergerecord processor at some point, generally I have about 5,000 records at the input and I need to merge them. Generally, it works ok, but sometimes somewhere along the way one or two records fall out and I get an error when merging that it cannot be merge because the quantity is not correct. This is also ok, but in such a situation I would like to receive an e-mail with information about the error in the merg. How can I make this e-mail come only once and not as many times as I have records in my flow? I've been struggling with this for the second day now and for now I receive an e-mail notification as many times as I have records that have not been merged.Maybe someone know how can I solve this problem?

MWM · ‎08-03-2023

hi, i have the following problem - i am creating myself quite a few json files via AttributeToJSON processor. Here, as destination, I have set flow-file content. Now I would like to combine them into one csv file. I used MergeContent in my flow first to combine them into one json and then ConvertRecord to turn it into csv. However, it does not create one file for me, but many, I do not know if the problem lies in the MergeContent processor or ConvertRecord. Or should I approach it differently? There are my settings in MergeContent

Online	Offline
Last Visited	‎02-12-2024 04:52 AM

Member Since	‎07-10-2023 07:48 AM
Last Visited	‎02-12-2024 04:52 AM
Posts	25
Kudos received	1

Cloudera Community

Re: Problem with trasform UUID to Strring in NIFI

Re: Problem with trasform UUID to Strring in NIFI

Re: Problem with trasform UUID to Strring in NIFI

Re: Problem with trasform UUID to Strring in NIFI

Re: Problem with trasform UUID to Strring in NIFI

Re: Problem with trasform UUID to Strring in NIFI

Re: Problem with trasform UUID to Strring in NIFI

Problem with trasform UUID to Strring in NIFI

Problem with sending mail in NIFI

How to merge many json files in one csv file in NI...