About SAMSAL

SAMSAL · ‎05-06-2022

have you tried Selected distinct * order by Date, ERROR_MSG

SAMSAL · ‎05-06-2022

It should not matter if the format of the text inside is like csv.

SAMSAL · ‎05-05-2022

you can do that using ExtractText Processor to extract the line that you need with word "bind" into an attribute using regular expression "(bind.+$)", then you ReplaceText processor to basically located the same line using the same regular expression and the the replacement value is the attribute from the ExtractText processor (assume its called XYZ) like this ${XYZ:replace(" ","")}

SAMSAL · ‎05-05-2022

Not sure if this is the best way but try using QueryRecord and create one dynamic property to funnel the data into where your query will look like this: Select distinct * from FLOWFILE

SAMSAL · ‎05-05-2022

if this is a csv file where the first line is the header, you can easily split the source into two flowfiles: one containing all keyword1 rows and another containing all keyword2 rows using QueryRecord Processor. After you set you record writer\reader to CSV you can create two dynamic properties representing each keyword, and set the query as follows: Keyword1: SELECT * FROM FLOWFILE WHERE KeyWord like 'KeyWord1' Keyword2: SELECT * FROM FLOWFILE WHERE KeyWord like 'KeyWord2'

SAMSAL · ‎04-08-2022

Hi, I have downloaded version 1.16 which is the latest. Im trying to secure nifi with TLS and LDAP. However I keep getting the followning message : Unknown user with identity 'CN=nifi_admin, OU=NIFI'. Contact the system administrator My Nifi,properties has the following set : nifi.security.user.authorizer=managed-authorizer nifi.security.user.login.identity.provider=ldap-provider If I have set as follows it works and it accepts the cert & authentication: nifi.security.user.authorizer=single-user-authorizer nifi.security.user.login.identity.provider=single-user-provider My Authorizer file has the identity set as follows: <userGroupProvider> ...<property name="Initial User Identity 1">CN=nifi_admin, OU=NIFI</property> </userGroupProvider> <accessPolicyProvider> ... <property name="Initial Admin Identity">CN=nifi_admin, OU=NIFI</property> <property name="Legacy Authorized Users File"></property> <property name="Node Identity 1"></property> ... </accessPolicyProvider> Im trying to log in first with the cert idenitity nifi_admin so I can start adding ldap users. If I log it as single user I dont see Users & Policies menu items. Can someone help point me in the right direction.

SAMSAL · ‎02-11-2022

Thank you so much, That did the trick. You seem to be a json jolt guru. Im trying to understand it myself but its not that straight forward. Can you just elaborate this syntax for me which remove null values on the base level: "*": { "*": { "@1": "&2" } } Why there is two asterisks in front of it?

SAMSAL · ‎02-10-2022

Hi, I have the following Json. I would like to create a Jolt Spec to remove all nulls from all levels. How can I do that? Any help would be appreciated. Thanks { "ID": "c22b657e-227b-4c65-e6f8-08d88a3e1118", "Name": "SomeName", "TaggedItemName": "SomeValue", "ITRName": "SomeValue", "TestReference": null, "JobCardName": null, "Comments": "test", "PrimaryHandoverName": null, "SecondaryHandoverNumber": null, "CertificationGroupingName": null, "DocumentCode": "SomeValue", "AssignedToName": "SomeName", "DocumentReference": null, "TagITRCompletionStatusName": "Rejected", "ScheduleRevision": null, "Completed": { "SignOff_AuthP": "John", "SignOff_Date": null }, "Accepted": { "SignOff_AuthP": "Smith", "SignOff_Date": null }, "Approved": { "SignOff_AuthP": "Ali", "SignOff_Date": null }, "ScheduleGroup": null, "DownloadUri": "SomeUrl", "UpdatedDate": "2022-01-18T11:36:33.9057626Z", "CreatedDate": "2020-11-30T10:57:20.8534287Z" }

SAMSAL · ‎11-04-2021

Hi, Best way I can think of store that attribute name in another attribute. You can also use execute script processor and read the attribute name you are looking for as in : var myAttr = flowFile.getAttribute('filename') and if the value is not null then you can route the flow File to the desired relationship. For more information on how to use the execute script processor: https://community.cloudera.com/t5/Community-Articles/ExecuteScript-Cookbook-part-1/ta-p/248922

SAMSAL · ‎10-14-2021

can you share the jolt script so I can take a look?

Online	Offline
Last Visited	‎12-31-2024 03:55 PM

Member Since	‎07-29-2020 02:31 PM
Last Visited	‎12-31-2024 03:55 PM
Posts	574
Kudos received	320

Cloudera Community

Re: CSVReader and CSVRecordSetWriter doesn't consi...

Re: Jolt spec to flatten the nested JSON

Re: CSVReader and CSVRecordSetWriter doesn't consi...

Re: Converting Nested JSON to Flat JSON using JOLT

Re: NIfi: javax.security.auth.login.LoginExceptio...

Re: Remove Duplicate Record values without cache s...

Re: [Nifi] How do I split comma separrated text f...

Re: find line with string and remove blank space n...

Re: Remove Duplicate Record values without cache s...

Re: [Nifi] How do I split comma separrated text f...

Unknown user with identity 'CN=nifi_admin, OU=NIFI...

Re: Json Jolt to Remove All Nulls from Json

Json Jolt to Remove All Nulls from Json

Re: How to route on attribute name?

Re: How to convert Nested JSON format in Apache Ni...