@nifi_pista , as this is an older article, you would have a better chance of receiving a resolution by starting a new thread. This will also provide the opportunity to provide details specific to your environment that could aid others in providing a more accurate answer to your question.  ... View more

@Dhwanil Raval I was able to follow the github link I have posted above and setup environment variable in openshift and apply them in the script start.sh The only thing I had to do is convert the script to the Unix format in my text editor as openshift was having trouble running it when deploying the pod and starting nifi. If you are having a specific issue I could help with that but currently its all working as described in github. ... View more

@Matt Clarke Another note, I tried Redis as well. That did not work as well. I pretty much get the same error. I will open an Apache NiFi ticket. Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flowService': FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flowController': FactoryBean threw exception on object creation; nested exception is java.lang.RuntimeException: Cannot use Local State Provider (org.apache.nifi.redis.state.RedisStateProvider) as it only supports scope(s) {CLUSTER} but instance is configured to use scope LOCAL Thanks for helping troubleshoot this. I will explore my next steps now perhaps a VM of NiFi cluster. ... View more

Thanks, I appreciate the quick response. I had to tweak the approach a bit, but this worked great! I used two routeonattribute processor as the not() was posing issues. First apply schema filter allows matches to flow through using below: ${anyDelineatedValue("${IncludeSchemaList}", ","):equalsIgnoreCase("${db.table.schema}")} Then I apply table filter and only allow unmatched to flow through, using below: ${anyDelineatedValue("${ExcludeTableList}", ","):equalsIgnoreCase("${db.table.name}")} ... View more

Hello @Shu, I am wondering how can use the same technique but to replace order by clause with nothing. I would like to not use order by at all. Thanks. ... View more