SQL query to count fields with values.

2023-09-07 Thread James McMahon
I have converted incoming Excel files to csv files. My incoming files vary in structure, and so do have different headers and also different field names. I have the header field names in an attribute. How can I employ a QueryRecord or an ExecuteSQL processor to return a count for each field of

Re: Help : LoadBalancer

2023-09-07 Thread Jens M. Kofoed
Hi Minh Sorry for the long reply :-) If you only have one load balancer in front of your NiFi cluster, you introduce a one-point of failure component. For High Availability (HA), you can have 2 nodes with load balancing in front of your NiFi cluster. proxy-01 will have one ip-address and

Re: Help : LoadBalancer

2023-09-07 Thread e-sociaux
  Hello Jens   Thanks a lot for haproxy conf.   Could you give more details about this point :   - I have 2 proxy nodes, which is running in a HA setup with keepalived and with a vip.-  - I have a dns record nifi-cluster01.foo.bar pointing to the vip address to keepalived   Thanks   

Re: Help : LoadBalancer

2023-09-07 Thread Jens M. Kofoed
Hi I have a 3 node cluster running behind a HAProxy setup. My haproxy.cfg looks like this: global log stdout format iso local1 debug # rfc3164, rfc5424, short, raw, (iso) log stderr format iso local0 err # rfc3164, rfc5424, short, raw, (iso) hard-stop-after 30s defaults log