Member since
02-15-2022
15
Posts
1
Kudos Received
2
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
1025 | 09-22-2022 10:20 PM | |
1219 | 03-16-2022 10:17 PM |
09-22-2022
10:20 PM
I just realised that NiFi only supports "Group by" and doesn't support "HAVING" clause. I had to put the queries in a python script and call an execute stream command processor.
... View more
08-26-2022
05:32 AM
@Olivia_4692 users usually screen shot, then blur anything you need to hide. Just capture the property/value settings modal, not entire screen of your computer. Not being able to see what you see, i will continue to make some suggestions. Since you are using Kerberos, the doc page i referenced has this property: Property DescriptionAuthenticationMethod {kerberos or userIdPassword}. Determines which authentication method the driver uses when establishing a connection. If set to kerberos, the driver uses Kerberos authentication. The driver ignores any user ID or password specified. If you set this value, you also must set the ServicePrincipalName property. If set to userIdPassword (the default), the driver uses user ID/password authentication. If a user ID and password is not specified, the driver throws an exception. The User property provides the user ID. The Password property provides the password. See Authentication for more information about using authentication with the Sybase driver. The default is userIdPassword. based on this i believe you should have AuthenticationMethod=kerberos in your jdbc url. There are further details for How to Configure Kerberos, please be sure to follow them all: https://docs.oracle.com/cd/E12839_01/web.1111/e13753/sybase.htm#JDBCD390
... View more
04-15-2022
10:16 PM
Could you probably give me an example of how to frame a Mongo query in NiFi ? My key to select the record is "my_id", which I get from an evaluate json path processor. The Columns that I want to update is a nested json key like so : ['a']['b']['exists_in_file']. The query that I now have in update Query Key is : {"$my_id":["a.b.exists_in_file":"True"]}. This errors our saying : BasicDBList cannot be cast to java.util.Map
... View more
03-17-2022
05:44 AM
@Olivia_4692 I'm happy to see you resolved your issue. Please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.
... View more
03-07-2022
01:26 AM
1 Kudo
@araujo - thank you so much. I referred to the same flow file you have attached. It works perfectly. The problem with mine was I was using two eval json processors and route on attributes wasn't able to compare from two different flowfiles.
... View more