@dulanga, as far as I can tell from your previous post, you have around 3GB of RAM Memory available on your NiFi node, but you are assigning much more to your JVM. So, you have: total used free shared buff/cache available Mem: 3.8Gi 1.5Gi 2.1Gi 145Mi 269Mi 2.1Gi Swap: 511Mi 511Mi 0B But you are assigning much more to your JVM: # JVM memory settings java.arg.2=-Xms4096m java.arg.3=-Xmx8192m   Try correcting your config files and assign the correct value for your JVM, in the bootstrap.conf file. Here are some best practices: https://community.cloudera.com/t5/Community-Articles/HDF-CFM-NIFI-Best-practices-for-setting-up-a-high/ta-p/244999   ... View more

yes code is same for small tables it works fine also, here I need to query around (~200GB) data ... View more